Michael Christofides

Making Postgres 42,000x slower because I am unemployed As an respectable unemployed person must do, I tried to make Postgres as slow as possible

Amazing post on making Postgres slower (yes, slower!) on purpose. byteofdev.com/posts/making... #postgres #postgresql Favorite bit: "random_page_cost = 1e300" LOL! Well done

YouTube video by PostgresTV MultiXact member space exhaustion | Postgres.FM 151 | #PostgreSQL #Postgres podcast

Really non-trivial case with MultiXacts and brilliant RCA and level of transparency from the Metronome team – great example of what to do with new types of #PostgreSQL incidents!

enjoyed discussion a lot! www.youtube.com/watch?v=9KoP...

YouTube video by PostgresTV Multigres | Postgres.FM 150 | #PostgreSQL #Postgres podcast

PostgresFM with Sugu, co-creator of Vitess, originally created to shard MySQL in YouTube, and then used by GitHub, Pinterest, Slack, Shopify, etc. Discussed his work at Supabase on Multigres, sharding for PostgreSQL. Enjoyed a lot!! Take it to a long hike or drive: youtu.be/KOepJivmWTg?...

3 years of PostgresFM 🥳

And now, @michristofides.com being back from 2-week break, and we've recorded our 150th episode

A very interesting one, don't miss -- this Friday

Postgres Meetup for All tomorrow www.meetup.com/postgres-mee...

YouTube video by Microsoft Developer Myths and Truths about Synchronous Replication in PostgreSQL | POSETTE: An Event for Postgres 2025

Amazing talk by Alexander Kukushkin about caveats and myths and truths of sync replication in Postgres.

Everyone who works or plans to work with sync replication must watch it!

www.youtube.com/watch?v=PFn9...

There are a couple of online #PostgreSQL events today that look like they'll be great:

16:00 UTC — 10 Costly Database Performance Mistakes (and How to Fix Them) with Andy Atkinson www.meetup.com/postgres-mee...

19:00 UTC — 12 years of Postgres Weekly with Peter Cooper aka.ms/TalkingPostg...

Hello, Bluesky!

Congrats Jimmy!

Deal of the Day Manning is an independent publisher of computer books, videos, and courses.

I have the great pleasure to announce the release of PostgreSQL Mistakes and How to Avoid Them in all formats! 🎉 To celebrate, @manningbooks.bsky.social is offering a Deal of the Day: 45% off my book and other selected titles! 👉 mng.bz/WrEx

#PostgreSQL #Postgres #TechBooks #Database #OpenSource

Is min short for minimum, or minutes?!!

Well I really like your framing, and other AI techniques like ML seem to mostly have almost the opposite characteristics (can get better than even the most specialised humans, but only at very narrow/highly constrained tasks!)

Very nicely put! It only strengthens your point, but I don’t think chess is even a counter example (other AI techniques sure, just not LLMs)

I actually didn’t, but enjoyed learning it from @raae.dev in the follow up blog post! 🥳

Postgres Meetup for All | Meetup Calling all Postgres enthusiasts! Do you work with Postgres? Do you want to be more involved in the community? Share your learnings? Join our vibrant online community dedicated to PostgreSQL, the worl...

Next week (14th) I'll be joining the excellent Postgres Meetup for All to demo and discuss troubleshooting slow queries using EXPLAIN and external tools: www.meetup.com/postgres-mee...

If you or your team could do with an intro or refresher, it would be great to see you there!

All sessions - PASS Data Community Summit

I'm proud to announce that I'm teaching a 1-day Postgres performance tuning class at the PASS Summit this year! Registration is open now, and if you register before May 13, you save big with early bird rates. passdatacommunitysummit.com/sessions/1103

Proud to be sponsoring PGDay UK. It’s lovely having a local event and it’s been great each time I’ve attended. It’ll be in London again on September 9th. Let me know if you’ll be there too!

P.s. they’re currently looking for speakers (and sponsors!)

YouTube video by PostgresTV 💙💛 Performance cliffs | Postgres.FM 140 | #PostgreSQL #Postgres podcast

Tomas Vondra is one of #PostgreSQL hackers with strong focus on performance and query optimization. Enjoyed this session a lot

📺 www.youtube.com/watch?v=hyMH...
🎙️ postgres.fm/episodes/per...

It was inspired by this talk: "Where do performance cliffs come from?" www.youtube.com/watch?v=UzdA...

While editing a podcast episode, I cringed twice whilst being confidently wrong about things. I need to work on that, or I need to stop criticising LLMs (or both!)

I’ve added it as an idea, but it might be a short answer! I think for the vast majority of use cases, the risk of data loss far outweighs the performance benefit. This really good article by Laurenz looks at some alternatives: www.cybertec-postgresql.com/en/commit_de...

Thank you Lukas, much appreciated on both fronts 🙏

After 6 years of hoping someone else would write this, I've finally succumbed to the little marketing devil on my shoulder and written about Postgres query plan visualization tools.

It's hard to imagine someone more biased about any topic, but here goes: www.pgmustard.com/blog/postgre...

Why I don't document quirks of a feature on the feature itself. Users are often inclined to suggest documenting workarounds for quirks using unrelated features on the features themselves, and why I think this is wrong.

Resisting the urge to document everything everywhere
blog.jooq.org/resisting-th...

Just listened, glad you're ok!!

Just because you’re getting an index scan, doesn't mean you can’t do better! - pgMustard An issue I often see folks missing when reviewing query plans, is that they see that all of their scans involve indexes and they think that the query is likely already as fast (or efficient) as it can...

It's incredibly common to see a Postgres query plan with all scans using indexes, and to think it's probably already optimal.

I've written a new post for the pgMustard blog about why that often isn't the case, and some things you can look out for:

www.pgmustard.com/blog/index-s...

Haha thank you Alicja, great to see you here 🙌

Thank you!

I'm honoured to have been added to the PostgreSQL Contributors list, along with Nikolay Samokhvalov! www.postgresql.org/community/co...

Thank you to everyone who makes Postgres what it is. I'm chuffed to be recognised as playing a small part in helping such a wonderful project ☺️✌️🐘

Postgres FM | pg_squeeze Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the functionality into core. Here are some links to t...

We just published an episode of Postgres FM on pg_squeeze with the wonderfully humble Antonín Houska.

If you’re currently managing bloat manually or with pg_repack, I highly recommend checking this out:

postgres.fm/episodes/pg_...

Release PgBouncer 1.24.0 · pgbouncer/pgbouncer 2025-01-10 - PgBouncer 1.24.0 - "New year, new bouncer" Features Add support for Type=notify-reload for systemd. This requires systemd version 253 or later. (#1148) Add KILL_CLIENT command t...

PgBouncer 1.24.0 is out, with many improvements. And prepared statement support is now turned on by default! github.com/pgbouncer/pg...