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.

Indexing "LIKE" in PostgreSQL and Oracle

by Laurenz Albe | 08.2023
© Laurenz Albe 2023 Unless you use the binary collation, creating a b-tree index to support a LIKE condition in […]

Bulk load performance in PostgreSQL

by Laurenz Albe | 08.2023
  There are several techniques to bulk load data into PostgreSQL. I decided to compare their performance in a simple […]

Killing performance with PostgreSQL partitioning

by Hans-Jürgen Schönig | 07.2023
Partitioning is not without risk. It might help to handle large quantities of data, but it can also have downsides - learn how to it.

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. […]
CYBERTEC Logo white
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