The “synchronous_commit” parameter and streaming replication
If you’re not yet familiar with the Postgres “synchronous_commit” parameter you should definitely keep reading. It’s one of the important-ish parameters with an above average amount of options, which could be a bit daunting for the casual DBA. And in soon to be released PostgreSQL 9.6 another new option called “remote_apply” was added so I […]
Is it worth spending more money on more disks?
“Our database is slow. What if we just buy more disks? Is it going to fix things?”. I think every PostgreSQL database consultant in the world has heard this kind of question already more than once. Of course the very same questions are asked by our customers here at CYBERTEC. While more disks are surely […]