A recap of our September meetup: my own talk on tiering cold Postgres data to Apache Iceberg, and Daniel Roe, who leads the Nuxt core team, on reaching Postgres from the other end of the stack. Next one is Thursday, October 15th.
Read more...
PostgreSQL events in Scotland now have their own address: postgres.scot. Plus a short recap of the August meetup, with Torsten Förtsch on getting your data out of a managed service and Paolo Guagliardo on marked nulls in PostgreSQL. Next up: Thursday, September 24th.
Read more...
A belated recap of my first PGConf.dev, in Vancouver, where Andreas Scherbaum and I presented a quantitative analysis of twelve years of commitfests: what happens to a patch after somebody sends it in, whether first-time authors come back, and how much review capacity there actually is.
Read more...
Yesterday I gave a talk at PGDay UK 2026 in London about pgSafe, a from-scratch Go rewrite of enterprise Postgres backups, and what pgBackRest's near-demise in April taught us. The talk covered what a backup tool really does, the invariants every backup tool has to uphold, my design tenets, where 100,000 lines of C went, and the parts no language can shrink.
Read more...
Sharing the video and slides from my July LinkedIn Live session with Manning, on what to do when you inherit a database that somebody else built badly: how to assess it, which fires to put out first, and how to stop it happening again.
Read more...
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.2 with PostgreSQL 19 support, a new blocking locks analysis module, and an OpenAI-compatible AI provider.
Read more...
My POSETTE 2026 and PG DATA 2026 talk on how PostgreSQL's LISTEN/NOTIFY can quietly bottleneck a high-throughput database, and how to fix it with unlogged queue tables, advisory locks, and batching.
Read more...
Sharing the video of my April LinkedIn Live session, where I break down common SQL anti-patterns from Chapter 2 of my book and fix them live in the terminal.
Read more...
A recap of our July meetup: Pat Wright on speaking and community involvement for the introvert, and Martins Otun on traceable, SQL-first retrieval for compliance-critical AI systems.
Read more...
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.0 with an optional AI analysis mode that produces per-module HTML reports with chart commentary, threshold verdicts, and concrete remediation advice from a cloud or local LLM.
Read more...
A look back at our April meetup and a call for speakers for our May Lightning Talks event! Test your talk before the PGDay UK CFP deadline.
Read more...
I just came back from SCaLE 23x! This year I spoke about running robust, self-healing PostgreSQL on Kubernetes with CloudNativePG, and caught up with community legends.
Read more...
A recap of our second meetup! Slides and resources from Alastair Turner's talk on client failover and Sean Hammond's deep dive into transactional job queues.
Read more...
A recap of FOSDEM 2026 in Brussels, where Daniël van Eeden and I explored what "compatible" really means for databases, plus an announcement for the next session in Vancouver!
Read more...
Floor Drees, Karen Jex and I led a panel at PGConf.EU 2025 about neurodiversity, teamwork hacks, and how diverse minds collaborate in the PostgreSQL ecosystem. Moderator: Boriss Mejías
Read more...
The PostgreSQL Edinburgh meetup returns! February 12th @ the University of Edinburgh's Lister Learning and Teaching Centre (pizza, networking, and talks).
Read more...
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.9 with configuration change timelines, new modules for replication, SLRU, and session age.
Read more...
A doodling habit led to what appears to be a novel way of visualizing prime numbers, using the primes as step lengths in a turtle walk. The result is a surprising geometric "proof" of the Prime Number Theorem.
Read more...
Thrilled to announce the launch of the PostgreSQL Edinburgh meetup! December 11th @ the University of Edinburgh's Old College (pizza, networking, and talks).
Read more...
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.8 with support for PostgreSQL 18.
Read more...
A recap of PGDay Lowlands 2025, where I presented our talk "How Do We Get Postgres to the Next Level?", co-written with Henrietta Dombrovskaya, in the unique setting of the Rotterdam Zoo.
Read more...
A quick recap of my trip to Portland for FOSSY 2025, where I had the opportunity to speak about building AI-powered applications with pgvector and Retrieval-Augmented Generation.
Read more...
I just came back from my second SCaLE (22x)! I broadcast 3 days of live streams from the conf, and spoke about Row-Level Security.
Read more...
PGConf.EU 2024 was huge, with new fringe events, and much enjoyment.
Read more...
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.7 with new features and support for PostgreSQL 17.
Read more...
A new PostgreSQL event has appeared, and it's DBA Appreciation Day today!
Read more...
Floor Drees and I just spoke at POSETTE 2024 about neurodiversity and mental health in IT & PostgreSQL Community!
Read more...
I just came back from my first Southern California Linux Expo (SCaLE 21x) where I shared a true story about a remarkable PostgreSQL data recovery.
Read more...
A few months back I gave a talk at FOSSCOMM 2023 in Heraklion, Greece — and the footage has just been found!
Read more...
PGConf.EU was a huge success, with many firsts and unforgettable moments.
Read more...
At PGConf.DE I gave a talk about what not to do with Postgres for the last (?) time.
Read more...
Just came back from FOSDEM 2023 where, among other things, I gave a talk about what not to do with Postgres.
Read more...
Just tried out a new panel talk format for PGConf.EU 2022 and feedback was great.
Read more...
So I got some lovely people together to discuss PostgreSQL upgradability at Postgres Vision.
Read more...
PostgreSQL is very particular about how it likes to deal with high concurrency, so let's look at potential pitfalls when you throw a lot of work at your database.
Read more...
/ blog
