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 […]
TCP keepalive for a better PostgreSQL experience
by
Laurenz Albe |
10.2021 (Updated 2023-06-22) If you've heard about TCP keepalive but aren't sure what that is, read on. If you've ever […]
WITH HOLD cursors and transactions in PostgreSQL
by
Laurenz Albe |
10.2021 Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
JSON in PostgreSQL: how to use it right
by
Laurenz Albe |
09.2021 The comprehensive JSON support in PostgreSQL is one of its best-loved features. Many people – particularly those with a […]
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 […]
From MD5 to scram-sha-256 in PostgreSQL
by
Laurenz Albe |
06.2021 Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can […]
For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]
