The “synchronous_commit” parameter and streaming replication
By Kaarel Moppel – If you’re not yet familiar with the Postgres “synchronous_commit” parameter, you should definitely keep reading. It’s one of the important parameters and contains an above-average number of options, which could be a bit daunting for the casual DBA. And in the soon to be released PostgreSQL 9.6, another new option called […]
Will more disks get you better PostgreSQL performance?
“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 […]