Pipeline mode for better PostgreSQL performance on slow networks
by
Laurenz Albe |
03.2022 It is known that high network latency is bad for database performance. PostgreSQL v14 has introduced “pipeline mode” for […]
Automatic partition creation in PostgreSQL
by
Laurenz Albe |
02.2022 Table partitioning is one of the best-liked features out of the more recent PostgreSQL developments. However, there is no […]
Entity-attribute-value (EAV) design in PostgreSQL - don't do it!
by
Laurenz Albe |
11.2021 Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a […]
PostgreSQL: Create indexes after bulk loading
This post describes when to create indexes, before or after bulk loading of the data. Improve your PostgreSQL performance by doing it right.
Index bloat reduced in PostgreSQL v14
by
Laurenz Albe |
09.2021 PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]
PostgreSQL: The power of a SINGLE missing index
This poem post shows the importance of even one missing index for a target PostgreSQL table from a performance perspective.
PostgreSQL vs Redis vs Memcached performance
PostgreSQL vs Redis vs Memcached: How would it look on the performance side, if one just skips the cache & hits the database directly?
Data warehousing: Making use of synchronized seq scans
Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.
How to interpret PostgreSQL EXPLAIN ANALYZE output
by
Laurenz Albe |
05.2021 UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]
PostgreSQL: Bulk loading huge amounts of data
This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.
