Live and recent posts from across the Fediverse tagged #posetteconf, aggregated by home.social.
New blog post: #PostgreSQL's LISTEN/NOTIFY is elegant and lightweight. It can also quietly bring a busy database to its knees. In my #POSETTE and PG DATA talk I dig into a real production incident and the fix that got us out of it.
https://vyruss.org/blog/listen-carefully-how-notify-can-trip-up-your-database.html
The EDB Engineering Newsletter is out! In this edition we talk about #loopengineering, our #POSETTEConf sessions, a collaboration with Red Hat (on Data Governance Co-pilot), the most recent database languages working group (WG3) offsite, and more: https://open.substack.com/pub/edbeng/p/edb-engineering-newsletter-19 #PostgreSQL
Bruce Momjian explains the WAL as basically being a change-log for the database. In his #PosetteConf talk he explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress: https://www.youtube.com/watch?v=T7lrE22tgkg#PostgreSQL
In this #PosetteConf panel Álvaro Herrera, Heikki Linnakangas (Databricks), Melanie Plageman, and Thomas Munro (both Microsoft) talk about what happens in the lead-up to a #PostgreSQL feature freeze, and about why some patches make the cut while others stall.
For an honest and relatable look at open source development: https://www.youtube.com/watch?v=Vw4WKeoxKq4
In "JSON in PostgreSQL - evil data type or just needs to be tamed?" Boriss Mejias works through a case study to create a pragmatic view of working with JSON/JSONB in #PostgreSQL: https://youtu.be/on8qjyOEwPk?si=toTkmrkJayi7oL3m #PosetteConf
Missed #PosetteConf last week? It's a good thing everything's recorded! Like the talk Leonardo Cecchi did with Jeremy Schneider (GEICO tech) on "Quorum-Based Consistency for Cluster Changes with CloudNativePG Operator" ensuring all users of #Postgres on #Kubernetes that they can trust Postgres to keep their data safe: https://www.youtube.com/watch?v=VrXSCbU3aa4
OK, so the keynote "Postgres 19 Hackers Panel: What’s In, What’s Out, & What’s Next" that Heikki Linnakangas, Thomas Munro, Melanie Plageman and I presented at POSETTE: An Event for Postgres has now been published on Youtube: https://www.youtube.com/watch?v=Vw4WKeoxKq4
I think it turned out quite okay.
There's still some conference talks to go! Have a look at https://posetteconf.com/2026/schedule/
RE: https://mastodon.social/@posetteconf/116756396333618314
A virtual event with physical SWAG, you ask? Yes! Drop by #posetteconf in the Microsoft Open Source Discord to get your POSETTE & Friends Sticker Pack, and POSETTE 2026 Socks!
Today #PosetteConf kicks off and our Boriss Mejias has a talk on the schedule! Join this great virtual event and gain a pragmatic view of working with JSON/JSONB in #PostgreSQL: https://posetteconf.com/2026/talks/json-in-postgresql-evil-data-type-or-just-needs-to-be-tamed/ @posetteconf
Two pgEdge engineers at #PosetteConf this Thursday, June 18 - free & virtual.
Hari Kiran: logical decoding in #PostgreSQL from 9.4 to today - CDC, zero-downtime migrations, and what's next for replication.
Jimmy Angelakos: NOTIFY acquires a cluster-wide exclusive lock. That LISTEN/NOTIFY trigger on a busy table can cause mysterious statement timeouts at scale.
Both in live chat for Q&A. Free to register: 👉