CYBERTEC PostgreSQL Logo

Tag: performance tuning

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: performance tuning.
You can go back to all blog posts or take a look into our other categories & tags.

PostgreSQL 18: Better I/O performance with AIO

by Hans-Jürgen Schönig | 09.2025
PostgreSQL 18 is around the corner and it is time to take a look at one of the most important […]

Partitioned table statistics

by Laurenz Albe | 09.2025
I recently helped a customer with a slow query. Eventually, an ANALYZE on a partitioned table was enough to fix […]

PostgreSQL storage: Comparing storage options

by Hans-Jürgen Schönig | 07.2025
PostgreSQL offers more than just traditional row storage. We benchmarked row store, column store, CSV, and Parquet across 144 million rows - see what storage really saves space and boosts performance.

SELECT FOR UPDATE considered harmful in PostgreSQL

by Laurenz Albe | 06.2025
© Laurenz Albe 2025 Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR […]

Indexing vectors in PostgreSQL

by Hans-Jürgen Schönig | 04.2025
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.

commit_delay for better performance: a PostgreSQL benchmark

by Laurenz Albe | 01.2025
We benchmark the performance boost that you can get by tuning commit_delay with a workload of small transactions.

Dealing with trigger recursion in PostgreSQL

by Laurenz Albe | 10.2024
This article describes the problem of endless trigger recursion in PostgreSQL and shows how to deal with it and get good performance.

Keyset pagination with descending order

by Laurenz Albe | 07.2024
This article shows how to use keyset pagination if you want to sort some columns in ascending and others in descending order.

Foreign keys in PostgreSQL: Circular dependencies

by Hans-Jürgen Schönig | 06.2024
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".

Why do I have a slow COMMIT in PostgreSQL?

by Laurenz Albe | 05.2024
This article describes the possible reasons for a slow COMMIT in PostgreSQL and discusses what you can to against that.
1 2 3 4
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram