pg_stat_io and PostgreSQL 16 performance
How to use pg_stat_io for true debugging power in PostgreSQL v16. Offers deep insights into database I/O behavior & performance.
"Why does my pg_wal keep growing?" That's a question I keep hearing again and again. It is an urgent […]
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 […]
View Access Logging - Fix it in PostgreSQL
How to fix the view access logging in an established database. Find out how Kirk Wolak renamed and tracked all the views in his Postgres DB.
Use HOT, so CLUSTER won't rot in PostgreSQL
by
Laurenz Albe |
06.2023CLUSTER is sometimes the last resort to squeeze performance out of an index scan. Normally, you have to repeat CLUSTER […]
ERROR: invalid byte sequence - Fix bad encoding in PostgreSQL
by
Laurenz Albe |
05.2023(Inscription seen on a T-shirt) It's annoying to get error messages caused by encoding problems. But it is more annoying […]
When talking to customers, sometimes I get the question: How should PostgreSQL installations deal with huge pages and large memory […]
PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained
by
Laurenz Albe |
05.2023 Many people have heard that ALTER DEFAULT PRIVILEGES makes it easy to allow other users access to tables. But […]
Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]
Docker and sudden death for PostgreSQL
by
Laurenz Albe |
05.2023 This is a short war story from a customer problem. It serves as a warning that there are special […]
