Neues vom PostgreSQL Planet

I often hear that PostgreSQL is not suitable for solving analytics problems, referencing TPC-H or ClickBench results as evidence. Surely, handling a straightforward task like sorting through 100 million rows on disk and calculating a set of aggregates, you would get stuck on the storage format and parallelisation issues that limit the ability to optimise the DBMS.

On 29th of July 2025, David Rowley committed patch: Display Memoize planner estimates in EXPLAIN   There've been a few complaints that it can be overly difficult to figure out why the planner picked a Memoize plan. To help address that, here we adjust the EXPLAIN output to display the following additional details:   1) … Continue reading "Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN"

Just a short post, because I thought this was pretty remarkable. Below, I have screenshots showing the CPU utilization of two AWS instances in us-west-2 which are running an identical workload.

I had the pleasure of speaking at PGConf.dev in Montreal, where I delivered a session on Columnar Data Store—a topic that’s quietly transforming the way we handle large-scale analytics in PostgreSQL. In this post, I’ll walk you through the core ideas from my talk and explain why columnar storage isn’t just a performance boost—it’s a game changer for modern data workloads.

Catching with all contributions. PGDay UK published their schedule. Registration is still open. Here is their program committee

PgDay UK