PostgreSQL checksums vs. Performance - Why we willingly sacrifice ~3% TPS (and sleep better)
At Hosted Power we’re performance addicts:
We tune kernels for fun.
We argue about shared_buffers at lunch.
We benchmark things nobody asked us to benchmark.
And then… we turned on a feature that slows Postgres down by ~3%.
In this article, we explain why a small performance trade off results in a major increase in data integrity and operational confidence, especially for ecommerce platforms and DevOps teams running mission critical workloads.
Read more