Issue 660 - What if Claude were your Postgres server? by ~postgresweekly

Postgres COUNT(DISTINCT) Too Slow? Fast Approximation Guide

https://www.snowflake.com/en/blog/engineering/postgres-count-distinct-approximation/

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.

15 days ago

Oracle Migration Calculator

https://www.enterprisedb.com/calculator/oracle-migration-calculator?step=0

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.

15 days ago

SQL Improvements in PostgreSQL 11–18: A Personal Selection

https://tapoueh.org/blog/2026/07/sql-improvements-in-postgresql-1118-a-personal-selection/

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.

15 days ago

A 13-year-old PostgreSQL bug, found by running Postgres on Kubernetes with CloudNativePG

https://www.enterprisedb.com/blog/13-year-old-postgresql-bug-found-running-postgres-kubernetes-cloudnativepg

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.

#postgresql #cloudnativepg #kubernetes #bug discovery #streaming replication #edb postgres

15 days ago

Turning Claude into Postgres so I can raise a Series A

https://byteofdev.com/posts/turning-claude-postgres/

🤖 '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! 😅

15 days ago

Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ) – select * from depesz;

https://www.depesz.com/2026/07/31/waiting-for-postgresql-19-sql-property-graph-queries-sql-pgq/

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!

15 days ago