Best of PostgreSQL 9.6 for the DBA
Here arethe most interesting and relevant features of PostgreSQL 9.6 for the PostgreSQL DBA - summarized for easy digestion.
The "synchronous_commit" parameter and streaming replication
If you're not yet familiar with the "synchronous_commit" parameter, keep reading. It's one of the most important PostgreSQL parameters.
Will more disks get you better PostgreSQL performance?
Find out whether to buy more hardware to fix performance problems - which are in many cases not caused by bad disk performance.
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.
Exploding runtime: How nested loops can destroy speed
What will happen if the PostgreSQL optimizer underestimates the number of rows involved in nested loops? Includes ways to fix the problem.
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.
Watch command - how to watch a PostgreSQL database
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.
UNIX sockets vs. localhost: PostgreSQL Performance advice
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
Registering PostgreSQL as a service on Windows with pg_ctl
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.
