Walbouncer update - a proxy for selective PostgreSQL physical replication
walbouncer update, now supporting PostgreSQL 14, together with a helper script to build replicas. How-to on the walbouncer set up process.
Insert-only data modeling with PostgreSQL?
Introduction to insert-only data modeling with PostgreSQL. And a test scenario for a possible use case, highlighting performance benefits
Logging of data modifications and the “log_statement” configuration parameter
A short reminder on how PostgreSQL logs executed statements. Also included: a closer look at the log_statement parameter.
Spying on slow statements with “auto_explain”
PostgreSQL "auto_explain" functionality is a useful debugging helper that many people don't know about. Describes setup and use cases.
PostgreSQL underused features - WAL compression
WAL compression is a new feature of PostgreSQL 9.5 that not many are yet aware of. This post provides a test case highlighting the benefits.
Estimating table bloat in PostgreSQL
A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.