What do you like most in Postgres 18? Look at www.postgresql.org/docs/release... and tell me. I'll go first, my top-3 list:

Some PG18 posts spread misinformation.. Be careful, we see a lot of LLM-generated BS lately.

this needs to be in PG core github.com/fabriziomell... or this github.com/munakoiso/lo...

If you deal with index bloat, and ready to try out a new thing – reach out to me, we're have something really cool

just merged: WAL-G now got Prometheus exporter github.com/wal-g/wal-g/...

levels of psql-fu: level 0: psql <connoptions> -c "SELECT 1;" level 1: pg_isready <connoptions> level 1: psql -c "select;" # conn. options in env vars ... level 99: psql -XAatcselect 2>&1 | ts | tee -a log

Canceling Disney+ subscription is a good idea today. It also has a "why" text field that is worth filling.

How do you define "bloat" in Postgres? Do you include dead tuples into bloat? Or only empty space (reclaimed and tracked by FSM, after VACUUM deletes dead tuples)?

[vibe]hacking Postgres online with Andrey, Kirk www.youtube.com/watch?v=mVYl... – it's live, join!

postgres_ai monitoring v0.8 is out – expert-level Postgres monitoring tool designed for humans and AI. GitHub: github.com/postgres-ai/... GitLab: gitlab.com/postgres-ai/... New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.

Zero-downtime major upgrades are one of key components of our Self-Driving Postgres vision, and our methodology is battle-tested by multiple PostgresAI customers. Gadget.dev just shared their battle notes -- full transparency on what worked (and what surprised them): gadget.dev/blog/zero-do...

Questions time! What Postgres question would you love to hear answered on the next PostgresFM podcast? 🔥

Just some facts about elephants after yet another visit to San Diego zoo: Elephants are highly social animals and, much like humans, they often look to strong, wise, and charismatic leaders to guide them. In elephant family groups, this role is filled by the matriarch. ..

Here is a simple synthetic demo of NOTIFY hot spot, drastically slowing down COMMIT (in any @PostgreSQL version) on a 48-vCPU AMD machine: gitlab.com/postgres-ai/.... (following up www.recall.ai/blog/postgre...) I couldn't get it on a smaller, 8-vCPU VM though.

[vibe]hacking @postgresql online with Andrey, Kirk www.youtube.com/watch?v=3Mle... – it's live, join! Session 3 of implementing "merge" for btree in Postgres (because now it has has only split) following Lanin&Shasha paper from 1986 (and today Andrey promises some good progress and first code!)

Careful: before PG17, autovacuum workers couldn't consume more than 1 GiB or RAM. And autovacuum_work_mem, by default, is -1, meaning it inherits from maintenance_work_mem. And we tend to raise maintenance_work_mem to, say, '2GB' or more. And often we raise number of workers... 1/2

[vibe]hacking @postgresql online with Andrey, Kirk www.youtube.com/watch?v=Ib3S... – it's live, join! Today we continue looking deeper at btree (aka nbtree) and see if we can implement merge (because now we have only split)

What are your biggest challenges with PostgreSQL automation?

what's your favorite LWLock?

As expected, CNPG went the repmgr route, trying to reinvent the wheel. My recommendation to avoid it (because split brain is possible) remains.

[vibe]hacking Postgres with Andrey, Kirk, Nik – live, join! www.youtube.com/watch?v=D1PE...

TIL: "DB rows" meaning for normal people (and Google!!) is very different than what you and I think, my dear follower

Fun byteofdev.com/posts/making...

Full-stack preview environments with DBLab 4.0: isolated databases for every pull request postgres.ai/blog/2025072...

Launch week day 4: Postgres how-tos – practical guides for real-world database challenges postgres.ai/blog/2025072...

One more thing for today: rules/guidelines for working with @PostgreSQL in your favorite AI copilot - Cursor, Claude Code, or GitHub Copilot: postgres.ai/rules (memorize this URL) Grab them to produce better code, schema designs. Improvement MRs are welcome.

Launch week day 3: Postgres AI Checkup service – expert-led, AI-assisted comprehensive database health assessment postgres.ai/blog/2025072...

[Vibe] coding with Andrey, Kirk, and myself – live session, join! Andrey is going to work on fixing more issues related MultiXacts www.youtube.com/watch?v=Szpq...

the latest 3 PostgresFM episodes are "multi" something all so different, and all were awesome discussions with our guests www.youtube.com/playlist?lis...

Following Supabase steps, we're launching our very first Launch Week! 🚀 5 days, 5 major releases of useful stuff for fast-growing startups running #PostgreSQL postgres.ai/launch-week What do you want Postgres AI to release?

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...

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?...

You know what I think about this, right? > It took me a while to figure out why several people struggled to reproduce the poor plan choices I saw. Then I realized they’re running with the default parameters, especially random_page_cost = 4 vondra.me/posts/so-why...

29y > 1.1.1.1 1996/07/09 06:21:07 scrappy Exp $ github.com/postgres/pos...

[Vibe] Hacking Postgres with Andrey, Nik, and Dmitry Fomin 20250709 - it's live, join us! www.youtube.com/watch?v=bfPd...

Another reason to celebrate 🥳 – 10 years of Patroni github.com/patroni/patr...

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

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...

Happy anniversary to MySQL (yesterday this page turned 20y) l: bugs.mysql.com/bug.php?id=1...

continue [Vibe] hacking PostgreSQL live – join! www.youtube.com/live/g9yl3zE...

[Vibe] hacking Postgres with Andrey and Kirk: today we'll look at the GiST support in amcheck www.youtube.com/watch?v=lI-V... – it's live, join!

I'm attending No Kings's event, “NO KINGS at the Duck Pond” - sign up now to join me! www.mobilize.us/nokings/even...

Vibe hacking @PostgreSQL journey with Andrey and Kirk continues – going to finish the "log LSN on DROP TABLE" patch www.youtube.com/watch?v=t6T3... -- it's live, join!

Fully agree, temp tables can easily bring various issues if used often / in loaded systems, including obscurity of troubleshooting and perf. degradation, so often I recommend removing them. Why would you want them and why regular tables would help? (Via kmoppel.github.io/2025-06-03-y...)

From @pganalyze.bsky.social newsletter: > In a talk earlier at the conference, we shared a behind-the-scenes look at a new extension we're building to capture per-plan statistics—similar to Aurora's aurora_stat_plans extension, but open-source Hats off @lukas.fittl.com if for this work!

Computer science created software engineers AI made them equal