Cutting Our P99 Latency in Half with Connection Pooling
We were opening a fresh Postgres connection per request. Here is how a pooler took our P99 from 340ms to 160ms.
Tag
4 posts tagged "postgres".
We were opening a fresh Postgres connection per request. Here is how a pooler took our P99 from 340ms to 160ms.
Shared tables, schema-per-tenant, or database-per-tenant? We picked one on purpose. Here is the reasoning.
A migration without a tested down path is a one-way door. We treat reversibility as a requirement, not a nicety.
Sharding bought us headroom and a pile of new problems. Pick your shard key like your job depends on it — because it does.