POSETTE: An Event for Postgres

It's that time of year—to save the date for POSETTE: An Event for Postgres, a free & virtual developer event organized by the Postgres team at Microsoft, in partnership with AMD. 🗓️ Save the date! 🗓️ POSETTE 2027 will take place on 30 & 31 March 2027 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Model Context Protocol (MCP) is an open standard that lets us connect LLMs to external systems. Pamela Fox @pamelafox.bsky.social (Microsoft) demonstrates designing MCP servers for PostgreSQL. 📺See Pamela's POSETTE 2026 talk on YouTube: www.youtube.com/watch?v=3_JP... #PosetteConf

Taiob Ali @sqlworldwide.bsky.social, Microsoft Data Platform MVP, compares PostgreSQL & SQL Server security models, including differences in user authentication, roles, & permissions at POSETTE 2026. 📺Catch Taiob's talk on YouTube: www.youtube.com/watch?v=E0BL... #PosetteConf

Scaling a Citus cluster isn't limited by adding a VM, it's limited by how long it takes to rebalance data safely. Muhammad Usama (Microsoft) covers shard rebalancing in Citus at POSETTE 2026. 📺Watch Muhammad's talk now on YouTube: www.youtube.com/watch?v=sqQe... #PosetteConf

Connection pooling is a primary scaling tool. Josef Machytka (credativ GmbH) digs into Linux and PostgreSQL and the Multiverse of Connections at POSETTE: An Event for Postgres 2026. 📺See Josef's talk on YouTube: www.youtube.com/watch?v=rSoK... #PosetteConf

What does it take to teach Postgres to 200+ field engineers? Paula Berenguel (Microsoft) shares what she's learned at POSETTE: An Event for Postgres 2026. 📺Watch Paula's talk on YouTube: www.youtube.com/watch?v=um7J... #PosetteConf

Optimizing your database with AI is tempting, but how can we do this in a risk-free way? In his POSETTE 2026 talk, Mohsin Ejaz of DBtune speaks about building safety tooling for risk-free AI tuning of Postgres. 📺Watch Mohsin's talk on YouTube: www.youtube.com/watch?v=0ZeL... #PosetteConf

Sakshi Nasha is on a mission to turn security into a design habit, not an afterthought, hear how in her talk about securing Postgres the right way at POSETTE: An Event for Postgres 2026. 📺Check out Sakshi's talk on YouTube: www.youtube.com/watch?v=FhCL... #PosetteConf

Fuzzing throws malformed, unexpected input at software to find the bugs humans miss. Adam Wolk (Microsoft) brings fuzzing to PostgreSQL at POSETTE: An Event for Postgres 2026. 📺View Adam's talk on YouTube: www.youtube.com/watch?v=F2DJ... #PosetteConf

Hacking on PostgreSQL can feel overwhelming: massive codebase, rigorous review culture & a long patch queue. Which is why Xuneng Zhou created a Guide to PostgreSQL Hacking at POSETTE 2026. 📺Stream Xuneng's talk on YouTube: www.youtube.com/watch?v=YY8U... #PosetteConf

random_page_cost has been 4.0 since 2002. Should you lower it on SSDs? PostgreSQL committer Tomas Vondra (Microsoft) digs in at POSETTE: An Event for Postgres 2026. 📺Check out Tomas's talk on YouTube: www.youtube.com/watch?v=lbrW... #PosetteConf

Marco Slot (Snowflake) explains how Postgres can become a better analytics database with pg_lake at POSETTE: An Event for Postgres 2026. 📺Catch Marco's talk on YouTube: www.youtube.com/watch?v=9COY... #PosetteConf

Choosing your Postgres infrastructure on Azure? Andrew Ruffin of AMD covers hardware options delivering 60%+ better performance at lower cost at POSETTE: An Event for Postgres 2026. 📺Watch Andrew's talk now on YouTube: www.youtube.com/watch?v=X88L... #PosetteConf

Large tables can create real problems at scale. Sarat Balijepalli (Microsoft) shares practical strategies for maintaining large tables in PostgreSQL at POSETTE: An Event for Postgres 2026. 📺See Sarat's talk on YouTube: www.youtube.com/watch?v=tIuO... #PosetteConf

Postgres has a huge array of features; many can make application development easier and reduce application complexity. In his talk for POSETTE 2026, Chris Ellis (Nexteam) reviews a range of use cases & PostgreSQL Design Patterns. 📺Watch on YouTube: buff.ly/AYOM2xn #PosetteConf

Upgrading Postgres can make queries faster with zero code changes. At POSETTE: An Event for Postgres 2026, Divya Bhargov (Microsoft) compares Postgres 17 & 18 execution plans side by side. 📺Take a look at Divya's talk on YouTube: www.youtube.com/watch?v=XCv9... #PosetteConf

As AI agents move to production, the hard part is reliable, context-aware data retrieval. Abe Omorogbe (Microsoft) shows how Postgres is becoming the backbone for agent workflows at POSETTE 2026. 📺Enjoy Abe's talk on YouTube: www.youtube.com/watch?v=gGhS... #PosetteConf

At POSETTE: An Event for Postgres 2026, Christian Miles @cjlm.ca from gdotv shows what works & what fails visualizing Apache AGE graph results in Postgres. Force-directed, layered, or topology-aware? 📺View Christian's talk on YouTube: www.youtube.com/watch?v=s3Wz... #PosetteConf

Maybe the B in JSONB stands for Beast? In his POSETTE: An Event for Postgres 2026 talk, Boriss Mejías (@tchorix.bsky.social) of EDB covers schema-design pitfalls, index strategies & TOAST tables for JSON/JSONB in PostgreSQL. 📺 Watch the talk on YouTube: www.youtube.com/watch?v=on8q... #PosetteConf

Your PostgreSQL tools should follow you wherever you code. Matt McFarland of Microsoft talks about PostgreSQL tooling across AI editors and agents, featuring VS Code and Cursor in his POSETTE 2026 talk. 📺 Check out Matt's talk on YouTube: www.youtube.com/watch?v=3IJs... #PosetteConf

What makes the cut before a Postgres feature freeze? In this POSETTE keynote panel, hear PostgreSQL committers & hackers Álvaro Herrera, Heikki Linnakangas, Melanie Plageman, & Thomas Munro unpack what made it into Postgres 19—and what didn’t. Enjoy: www.youtube.com/watch?v=Vw4W... #PosetteConf

Microsoft is deeply invested in Postgres—upstream & in the cloud. In this POSETTE 2026 keynote, Affan Dar & Charles Feddersen share a technical look at core Postgres contributions, dev tools & why Microsoft built Azure HorizonDB. Watch now: www.youtube.com/watch?v=E2s9... #PosetteConf

As POSETTE: An Event for Postgres 2026 wraps, a special thanks to AMD for their partnership in bringing this free & virtual developer event to you. Along with gratitude to all the Postgres speakers, users, developers, & contributors who made this year’s event a success. #PosetteConf #AMD

Missed the livestreams at POSETTE 2026? Full replays are now on YouTube! Browse the 4 livestreams, jump to Postgres topics you care about, watch at your own speed, & catch host banter between talks. Feedback is a gift: Talk Surveys close Mon 22 Jun 11:59pm AoE aka.ms/posette-live... #PosetteConf

All talks from POSETTE: An Event for Postgres 2026 are now on YouTube. Hear from 50 speakers on Postgres 19, performance, PG internals, WAL, replication, AI & MCP, security, Azure HorizonDB, and the future of PostgreSQL. Watch the talks: aka.ms/posette-play... #PosetteConf

Thank you to all who joined the livestreams at POSETTE: An Event for Postgres 2026—and the virtual hallway track on Discord! We hope you came away with new ideas & inspiration. Good news: all 44 POSETTE talks are now available on YouTube: aka.ms/posette-play... #PosetteConf

Happening soon at #PosetteConf Livestream 4 on Thu 18: Hamid Akhtar (Microsoft) on "Where Does My INSERT Go? A Logical Replication Story" and what changed from 2009 to today. Join live to chat with Hamid in the virtual hallway track on Discord. posetteconf.com