COUNT(DISTINCT) Too Slow? A Guide to Fast Approximations — A thorough, hands-on look at Postgres's powers of approximation and sampling, covering the pros, cons, and performance profiles of approaches including TABLESAMPLE, hll, and Apache DataSketches, on a 10 million row test table.

Elizabeth Garrett Christensen (Snowflake)

Model the Cost of an Oracle-To-Postgres Move — Weighing a move off Oracle? EDB's free calculator lets you model the cost by database tier and support level. Pressure-test the migration in a few minutes, before you commit to anything.

EDB sponsor

SQL Improvements in Postgres 11–18: A Personal Selection — Eight releases' worth of SQL features, picked by a longtime contributor and grouped by topic. The part on modelling band membership over time with tstzmultirange and range_agg() alone is worth a look, but there's much to enjoy.

Dimitri Fontaine

Unveiling a 13-Year-Old Postgres Bug in Cascading Replication — A guard added to streaming replication in Postgres 9.3 could lock a cascading standby out of streaming from its upstream after falling back to archive recovery. It's been fixed and will land in the next minor releases: 18.5, 17.11, and so on.

Gabriele Bartolini (EDB)

🤖 'Turning Claude into Postgres So I Can Raise a Series A' — What happens when you stick an LLM behind the Postgres wire protocol and just let it deal with queries however it wants? This, apparently. Yes, it's a bit of fun, but he really did implement actual storage APIs for it to use! 😅

Jacob Jackson

Waiting for Postgres 19: SQL Property Graph Queries (SQL/PGQ) — If you've wondered what SQL property graph queries buy you over just using normal joins, you're not alone!

Hubert depesz Lubaczewski