#PosetteConf
LightNews LightNews
pamelafox.fosstodon.org.ap.brid.gy
Wrote a new blog post:
"Building safe servers for your PostgreSQL database"
https://blog.pamelafox.org/2026/08/building-safe-mcp-servers-for-your.html

That's based on my @posetteconf talk, recording here:
https://www.youtube.com/watch?v=3_JPHuXgDyQ
Spectrum of ways to build PostgreSQL MCP servers
August 12, 2026 at 6:09 PM
posetteconf.com
What really happens to an INSERT in PostgreSQL once it enters the system? Hamid Akhtar of Microsoft presents: Where Does My INSERT Go? A Logical Replication Story at POSETTE: An Event for Postgres 2026

📺Take a look at Hamid's talk on YouTube:
buff.ly/oWAYGhw

#PosetteConf
July 15, 2026 at 6:30 PM
vyruss.org
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.

vyruss.org/blog/listen-...

#Postgres #PGDATA2026 #POSETTEconf
LISTEN Carefully: How NOTIFY Can Trip Up Your Database
My POSETTE 2026 and PG DATA 2026 talk on how PostgreSQL's LISTEN/NOTIFY can quietly bottleneck a high-throughput database, and how to fix it with unlogged queue tables, advisory locks, and batching.
vyruss.org
July 15, 2026 at 4:45 PM
posetteconf.com
PostgreSQL 18 introduces temporal keys, NOT ENFORCED constraints & promotes NOT NULL to a first-class constraint. Gülçin Yıldırım Jelínek @apatheticmagpie.bsky.social (Xata), covers it all at POSETTE 2026.

📺Enjoy Gülçin's talk on YouTube:
www.youtube.com/watch?v=9e-_...

#PosetteConf
July 15, 2026 at 1:32 PM
posetteconf.com
Postgres 18 delivers major VACUUM & ANALYZE improvements: async I/O, dynamic autovacuum scaling, eager freezing & better observability. Shashikant Shakya (Microsoft) walks through key enhancements at POSETTE 2026.

📺Watch his talk on YouTube:
buff.ly/AXFZCwj

#PosetteConf
July 14, 2026 at 6:32 PM
posetteconf.com
LISTEN/NOTIFY is elegant—but NOTIFY takes a cluster-wide exclusive lock that can cause timeouts under high concurrency. In Jimmy Angelakos’ @vyruss.org POSETTE 2026 talk you'll learn about this feature, its risks, & how to mitigate them.

📺Watch now:
www.youtube.com/watch?v=gVsU...

#PosetteConf
July 14, 2026 at 1:31 PM
posetteconf.com
What if you could run analytical queries inside Postgres without an ETL pipeline? At POSETTE 2026, Nitin Jadhav (Microsoft) demos pg_duckdb on Azure Database for PostgreSQL, querying tables & Parquet files from object storage.

📺Watch on YouTube:
www.youtube.com/watch?v=QrXx...

#PosetteConf
July 13, 2026 at 6:32 PM
posetteconf.com
How do you diagnose whether a Postgres bottleneck is CPU, I/O, or network? In Rahila Syed’s talk for POSETTE 2026, she walks through iterative profiling with perf & pgbench, showing how bottlenecks shift during optimization.

📺Watch on YouTube:
www.youtube.com/watch?v=oZHh...

#PosetteConf
July 13, 2026 at 1:32 PM
posetteconf.com
Postgres offers many authentication methods, but most users only encounter 1 or 2, often without understanding why they exist. In his POSETTE 2026 talk, Murat Tuncer (Microsoft) gives a tour of authentication’s evolution.

📺See the talk on YouTube:
www.youtube.com/watch?v=51IW...

#PosetteConf
July 13, 2026 at 12:54 PM
posetteconf.com
Postgres devs rely on PostgreSQL functions, procedures, & SQL logic, yet largely test them as black boxes. Hear about another way from Pavlo Golub @pavlogolub.bsky.social of Cybertec as he discusses pgcov for POSETTE 2026.

📺Watch Pavlo's talk:
www.youtube.com/watch?v=oHhI...

#PosetteConf
July 12, 2026 at 6:31 PM
posetteconf.com
Why does Postgres sometimes pick a Sequential Scan over an Index Scan? The answer often lies in statistics. Watch the pg_stats talk from Richard Yen (Microsoft) at POSETTE: An Event for Postgres 2026.

📺Enjoy Richard's talk on YouTube:
www.youtube.com/watch?v=CvvA...

#PosetteConf
July 12, 2026 at 1:30 PM
posetteconf.com
The Postgres write-ahead log, or WAL, is basically a change-log for the database. In his talk for POSETTE: An Event for Postgres 2026, Bruce Momjian of EDB explains it to us.

📺View Bruce's talk on YouTube:
www.youtube.com/watch?v=T7lr...

#PosetteConf
July 11, 2026 at 6:30 PM
posetteconf.com
Migrating multi-terabyte Oracle databases to PostgreSQL? Adithya Kumaranchath (Microsoft) shares proven strategies for minimal downtime at POSETTE: An Event for Postgres 2026.

📺Stream Adithya's talk on YouTube:
www.youtube.com/watch?v=i4mb...

#PosetteConf
July 11, 2026 at 1:30 PM
posetteconf.com
Logical replication in Postgres was once a low-level decoding API and now powers CDC, zero-downtime migrations, & analytics. Hari Kiran (OpenSource DB) presents on its past & its future at POSETTE 2026.

📺See Hari's talk on YouTube:
www.youtube.com/watch?v=2XPs...

#PosetteConf
July 10, 2026 at 6:30 PM
posetteconf.com
Learn what graphs in Postgres and Ticket to Ride have in common when you watch Ashutosh Bapat of Microsoft present on: "Exploring property graphs with SQL/PGQ in PostgreSQL" at POSETTE 2026.

📺Watch Ashutosh's talk on YouTube:
www.youtube.com/watch?v=LUKC...

#PosetteConf
July 10, 2026 at 1:32 PM
posetteconf.com
In this talk, Dingding Lu (Microsoft) shares why Microsoft built Azure HorizonDB for PostgreSQL, a shared storage architecture engineered for performance & scale at POSETTE: An Event for Postgres 2026.

📺Watch Dingding's talk now on YouTube:
www.youtube.com/watch?v=U3ss...

#PosetteConf
July 10, 2026 at 3:16 AM
posetteconf.com
Chun Lin Goh (.NET Foundation Member) models Postgres performance on burstable cloud instances, showing how to calculate the exact saturation point before CPU credits run out at POSETTE 2026.

📺Take a look at Chun Lin's talk on YouTube:
www.youtube.com/watch?v=71c7...

#PosetteConf
July 9, 2026 at 6:32 PM
posetteconf.com
Three years of Postgres partitioning mistakes—so you don't have to. Derk van Veen (Adyen) shares his Postgres partitioning cookbook at POSETTE: An Event for Postgres 2026.

📺Enjoy Derk's talk on YouTube:
www.youtube.com/watch?v=R0yr...

#PosetteConf
July 8, 2026 at 6:31 PM
posetteconf.com
Postgres is no longer just a transactional workhorse, instead, it’s turning into the everything database. Varun Dhawan @ivarund.bsky.social (Microsoft) walks us through what’s going on in his talk for POSETTE 2026.

📺View Varun's talk on YouTube:
www.youtube.com/watch?v=nmgj...

#PosetteConf
July 8, 2026 at 1:30 PM
posetteconf.com
Sai Krishna Srirampur (ClickHouse) demonstrates that, for very large datasets, bottlenecks are often due to slow storage not Postgres in his talk for POSETTE: An Event for Postgres 2026.

📺Stream Sai's talk on YouTube:
www.youtube.com/watch?v=h7by...

#PosetteConf
July 7, 2026 at 6:31 PM
posetteconf.com
Did you know you can build event-driven architectures directly on PostgreSQL using its write-ahead log & Drasi. Diaa Radwan (Microsoft) compares CDC approaches at POSETTE: An Event for Postgres 2026.

📺Check out Diaa's talk on YouTube:
www.youtube.com/watch?v=TtQf...

#PosetteConf
July 7, 2026 at 1:31 PM
posetteconf.com
Paula Santamaría and Julia Schröder Langhaeuser of Serenity Star talk about “Production RAG at Scale with Azure Database for PostgreSQL” at POSETTE: An Event for Postgres 2026.

📺Catch Paula and Julia’s talk on YouTube:
www.youtube.com/watch?v=RN5F...

#PosetteConf
July 6, 2026 at 6:32 PM
posetteconf.com
PgQ brings lockless queuing to Postgres. Alexander Kukushkin (Microsoft), the Patroni guy, shows how at POSETTE: An Event for Postgres 2026.

📺See Alexander's talk on YouTube:
www.youtube.com/watch?v=N5b0...

#PosetteConf
July 6, 2026 at 1:31 PM
posetteconf.com
At POSETTE: An Event for Postgres 2026, Jeremy Schneider (GEICO) & Leonardo Cecchi (EDB) explore how quorum consistency applies to Postgres cluster changes in the CloudNativePG operator.

📺Watch Jeremy and Leo's talk on YouTube:
www.youtube.com/watch?v=VrXS...

#PosetteConf
July 5, 2026 at 1:31 PM
posetteconf.com
Postgres 18 makes generated columns virtual by default. Paolo Melchiorre @paulox.net, Python developer & Django contributor, explores what this means using concrete examples at POSETTE: An Event for Postgres 2026.

📺Check out Paolo's talk on YouTube:
www.youtube.com/watch?v=wExo...

#PosetteConf
July 2, 2026 at 6:30 PM