Simon Riggs | #PostgreSQL Person of the Week j.mp/3dEAlXE

I have joined AWS. I'll be on the RDS open source team. My work on Postgres will continue at Amazon.

If transaction ID wraparound happened (the worst nightmare of a PostgreSQL DBA), most would use single-user mode and wait many hours to VACUUM the whole database. Hannu Krosing explains that there is a better way: youtube.com/clip/UgkxiAEBW…

We just completed reindexing the production YNAB database and it shaved off 27% of disk use.

Flying to Berlin for PGConf Europe tonight. Looking forward to catching up with everyone!

Christoph Engelbert / Noctarius ツ / エンゲルベルト クリス Franck Pachot The regular tables and indexes went from 76 GB to 49 GB, so around 35%. I'll be writing a detailed blog post about it :)

more metrics in pg16! pg_stat_io, and now this

AWS has dramatically increased its contributions with PostgreSQL 16 by understanding the project history and working closely with the community says core team member Jonathan S. Katz. #OSSummit #AWSCloud #opensource AWS Open Source

Simon Riggs was a visionary software developer who contributed fundamental work on the PostgreSQL database, replication and so much more. He was my business partner and mentor for a period where we wrote a pair of books together. I will miss him. metro.co.uk/2024/03/27/pla…

Simon Riggs gave me my start as a Postgres contributor back in 2011. He saw something in me at a time when it really mattered. I'll miss him.

Real talk about the challenges faced by PostgreSQL developers/hackers is something that I very much welcome. Kudos for normalizing it, Robert Haas.

New episode: "Skip scan" Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. 🎧 postgres.fm/episodes/skip-… 📺 youtu.be/Xk-znJgQzQs

We’re excited about Postgres 17! Brandur from our team was able to do some production testing on perf gains and its looking like you might get a 20-30% boost on some index scans. 🎉🕺

Postgres 17 is released with great performance features! In this video I discuss one of the major performance features with BTree scan optimization when using IN with constant values. In prior releases, postgres would loop and do multiple "primitive" index scans as many as