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
#postgres
4 posts tagged "postgres".
Building a Multi-Tenant Database Schema That Scales
Shared tables, schema-per-tenant, or database-per-tenant? We picked one on purpose. Here is the reasoning.
Writing Migrations You Can Roll Back
A migration without a tested down path is a one-way door. We treat reversibility as a requirement, not a nicety.
Lessons from Sharding PostgreSQL
Sharding bought us headroom and a pile of new problems. Pick your shard key like your job depends on it — because it does.