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.

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.

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.

EDB walks through what made it into Postgres 19 RC1, including REPACK CONCURRENTLY, pg_plan_advice, parallel autovacuum and sequence sync in logical replication, each with a checklist of what to test before upgrading.

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.