"Why does my pg_wal keep growing?" That's a question I keep hearing again and again. It is an urgent […]
Transaction ID wraparound: a walk on the wild side
by
Laurenz Albe |
01.2023 Most people are aware of transaction ID wraparound. The concept has been well explained in Hans' article, so I […]
Reduce WAL by increasing checkpoint distance
Adjusting checkpoints is useful when tuning a server and improves the database performance. Furthermore, it helps to reduce WAL.
Never lose a PostgreSQL transaction with pg_receivewal
by
Laurenz Albe |
10.2019 “Durability”, the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal […]
Checkpoint distance and amount of WAL
Tuning the database server affects the amount of WAL written to disk. Fewer checkpoints are a good idea for bigger databases.
