Robert Haas

October's hacking workshop will cover my talk, pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?.

I'm pleased to announce that David Rowley will be joining us in September to discuss his talk Optimizing code in the hot path; with examples from tuple deformation.

I was hoping to usual resume the monthly cadence of hacking workshops in June, but it didn't quite happen, largely due to being a little exhausted after pgconf.dev.

I'm planning to hold a single hacking workshop for April and May combined, covering Masahiko Sawada's talk, Breaking away from FREEZE and Wraparound, given at PGCon 2022.

I'm proposing a very ambitious patch set for PostgreSQL 19.

For next month's hacking workshop, I'm scheduling 2 or 3 discussions of Tomas Vondra's talk, Performance Archaeology, given at 2024.PGConf.EU.

Here is another annual blog post breaking down code contributions to PostgreSQL itself (not ecosystem projects) by principal author.

For next month, I'm scheduling 2 or 3 discussions of Amit Langote's talk, Hacking Postgres Executor For Performance, given at PGConf India 2025.

The PostgreSQL Hacking Workshop will be taking a well-earned Christmas break in December of 2025.

For next month, I'm scheduling 2 or 3 discussions of Matthias van de Meent's talk, Improving scalability; Reducing overhead in shared memory, given at 2025.pgconf.dev (talk description here).

Next month, I'll be hosting 2 or 3 discussions of Thomas Munro's talk, Investigating Multithreaded PostgreSQL, given at 2025.pgconf.dev (talk description here).

Next month, I'll be hosting 2 or 3 discussions of David Rowley's talk, Writing fast C code for a modern CPU (and applying it to PostgreSQL), given at 2025.pgconf.dev (talk description here).

I started running PostgreSQL Hacking Workshops just about one year ago, and I've run one each month, except for May, when we had pgconf.dev.

Next month, I'll be hosting 2 or 3 discussions of Tomas Vondra's talk, Fast-path locking improvements in PG18, given at 2025.pgconf.dev (talk description here).

Next month, I'll be hosting 2 or 3 discussions of Masahiko Sawada's talk, PostgreSQL meets ART - Using Adaptive Radix Tree to speed up vacuuming, from 2024.pgconf.dev.

Here are a few mentoring-related updates.Read more »

This month, I'm excited to tell you about the returning of the PostgreSQL Hacking Workshop along with a new Patch Review Workshop organized by Paul Jungwirth.Read more »

People continue to tell me on a semi-regular basis how much they appreciate these approximately annual posts, the first of which came out in April of 2017.

Please considering joining us next month (February 2025) for a discussion of Heikki Linnakangas's talk on The Wire Protocol, from PGCONF.EU 2024.

The call for proposals for 2025.pgconf.dev has been extended to January 6, 2025, otherwise known as "very soon".

Next month, I'l be hosting 2 or 3 discussions of Andres Freund's talk, NUMA vs PostgreSQL, given at PGConf.EU 2024.

Next month, I'll be hosting a discussion of Melanie Plageman's talk, Intro to Postgres Planner, given at PGCon 2019.

I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool?.

Next month, I'll be hosting a discussion of a talk by Andy Pavlo, given for his Intro to Database Systems course at CMU.

Recently, I've been hearing a lot of experienced PostgreSQL users reiterate this line: "pg_dump is not a backup tool."

This month, I'll be hosting a discussion of Thomas Munro's 2024.pgconf.dev talk, Streaming I/O and vectored I/O.