CYBERTEC PostgreSQL Logo

Category: Performance

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

Reproducible builds: a PostgreSQL query optimization example

by Christoph Berg | 07.2023
This post shows how to optimize a slow query that came out of the Reproducible Builds project. The Reproducible Builds […]

Subqueries and performance in PostgreSQL

by Laurenz Albe | 07.2023
  SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]

Unexpected downsides of UUID keys in PostgreSQL

by Ants Aasma | 06.2023
There are various compelling reasons to use universally unique identifiers (UUID) as primary keys. Two examples are: To be able […]

Use HOT, so CLUSTER won't rot in PostgreSQL

by Laurenz Albe | 06.2023
CLUSTER is sometimes the last resort to squeeze performance out of an index scan. Normally, you have to repeat CLUSTER […]

Huge Pages and PostgreSQL

by Bernd Helmle | 05.2023
When talking to customers, sometimes I get the question: How should PostgreSQL installations deal with huge pages and large memory […]

Forcing a join order in PostgreSQL

by Laurenz Albe | 05.2023
  Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]

EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16

by Laurenz Albe | 04.2023
  A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. […]

Parallel aggregate - PostgreSQL 16 - better performance

by Pavlo Golub | 04.2023
What is a parallel aggregate? In PostgreSQL, a parallel aggregate refers to a way of processing aggregate functions (such as […]

Row locks in PostgreSQL

by Laurenz Albe | 04.2023
  The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]

PostgreSQL: DELETE vs. TRUNCATE

by Hans-Jürgen Schönig | 03.2023
Archiving and database cleanup in PostgreSQL: Find out how DELETE and TRUNCATE compare in terms of performance and how the magic works
1 2 3 4 … 17
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.

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