All news

pgEdge digs into Postgres numeric internals to explain why aggregates over numeric are much slower than over integer or float types, and what could make them faster.

A field report showing that recovery_prefetch on Postgres replicas can quietly cause outages, how it was diagnosed, and when to turn it off.

Shard keys should come from your access patterns, not your tables: co-locating orders with customers by customer_id avoids cross-shard joins in sharded Postgres.

StackGres benchmarks open-source Citus at 10M QPS on half the data nodes PlanetScale used for its sharded Postgres Neki, arguing Citus is the more efficient option at that scale.

depesz benchmarks audit-log triggers and finds hstore can beat jsonb when logging only changed columns, with numbers on log size and trigger cost.

Postgres ON DELETE CASCADE can delete huge row counts in one transaction, causing long locks and surprises, so explicit batched deletes are safer.

PGX runs thousands of isolated throwaway Postgres-compatible databases in one Rust process, each cloned from a template in milliseconds, aimed at agent sandboxes and per-PR tests. Beta, dev use only.

Postgres 19 RC1 is out with GA close; what changed and what to test now.

DocumentDB 1.0, now a Linux Foundation project, is a generally available MIT-licensed document database that speaks the MongoDB wire protocol and stores native BSON inside PostgreSQL.

pgBackRest 2.60 now stops a restore with an error when it finds invalid page checksums, instead of restoring silently corrupted data.