SaaS Metrics
Database Scaling & Optimization
Postgres
AI Synthesis & Market Narrative
Postgres continues to be a focal point for database scaling and optimization, with discussions ranging from performance bottlenecks in `SELECT DISTINCT` to achieving extreme query rates via sharding on platforms like Neki. Configuration complexities with tools like Prisma and pgbouncer on Supabase highlight the need for careful tuning, while broader market shifts include vendor loyalty considerations in cloud services.
Correlated Linguistic Patterns
["Postgres SELECT DISTINCT"
"DigitalOcean leaving"
"AI assistants shared memory"
"Prisma pgbouncer Supabase"
"118M Queries per Second"
"Neki sharded Postgres"]
Driving Media Context
Postgres SELECT DISTINCT Does Not Scale
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
Leaving DigitalOcean, one site at a time
DigitalOcean is giving $3 million to the foundation behind DHH's Omarchy. I'd already moved my sites off it that weekend, so here's how the move went.
I stopped re-explaining myself to Claude and Gemini by giving them one shared memory
Sharing memory between AI assistants works, just not equally well.
Prisma's pgbouncer=true on Supabase made every query 4 round-trips (postmortem)
A guest's crashed booking page led to a one-line database config fix that made most screens of our hotel software three to four times faster. We had the numb...
WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL
WalShadow replicates Postgres data directly from physical WAL into ClickHouse, delivering around 200 ms latency and 289,000 rows per second in benchmarks.
118M Queries per Second on Neki
We ran a massive, sharded Postgres database at 118.5 million queries per second, with 200k queries per second on each shard across 512 shards.
Neki by PlanetScale
Sharded Postgres by PlanetScale. Scale real Postgres to hundreds of millions of QPS and petabytes of data with zero-downtime resharding.
Neki
Neki, sharded Postgres by PlanetScale, is now available in platform preview.
Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam
If you have spent any time in the Postgres community, you already know the name pgstef. Stefan Fercot has spent years as one of the most visible advocates fo...
Open Source Durable Objects for Postgres
An open-source library that runs the Durable Objects programming model inside a Rails or Node application, backed by SQLite, PostgreSQL, or MySQL.