Technology, Information and Internet
Free & virtual developer event organized by the Postgres team at Microsoft.
About us
POSETTE: An Event for Postgres is a virtual and free developer event—organized by the Postgres team at Microsoft. All 44 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, the future of PostgreSQL and more. https://aka.ms/posette-playlist POSETTE = Postgres Open Source Ecosystem Talks Training & Education | Pronounced “/Pō-zet/” Learn more about POSETTE at https://posetteconf.com
- Industry
- Technology, Information and Internet
- Company size
- 2-10 employees
- Type
- Nonprofit
- Founded
- 2022
Updates
-
POSETTE: An Event for Postgres reposted this
Missed POSETTE 2026? We've got you covered. Explore talks from PostgreSQL experts, covering AI-powered applications, performance, migrations, extensions, open source innovation, and so much more. Watch now, on demand.
-
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 In this talk, Hamid traces the complete lifecycle of one tuple as it travels through PostgreSQL’s logical replication pipeline. 📺Check out Hamid's talk on YouTube: https://lnkd.in/eSJ_M6EX #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 (Xata), covers it all at POSETTE: An Event for Postgres 2026. In her talk “What’s new with constraints in Postgres 18”, Gülçin also explains how constraint handling for partitioned tables has improved, plus, a sneak peek at what’s coming in PostgreSQL 19. 📺See Gülçin's talk on YouTube: https://lnkd.in/e-NcQaa8 #PosetteConf
-
PostgreSQL 18 delivers major VACUUM & ANALYZE improvements: async I/O, dynamic autovacuum scaling, eager freezing & better observability. Shashikant Shakya (Microsoft) covers what changed & how it affects real-world workloads at POSETTE: An Event for Postgres 2026. Shashikant walks through key enhancements in detail, including: + How AIO overlaps reads with processing to reduce heap-scan delays and speed up VACUUM + Adjust autovacuum_max_workers on the fly without restarts for elastic maintenance + Use autovacuum_vacuum_max_threshold & hard caps to prevent bloat on large tables + Reclaim unused space at the end of tables without blocking operations + Use recursive VACUUM/ANALYZE to handle inheritance-based partitions seamlessly 📺Watch Shashikant's talk on YouTube — or choose from any of the 44 POSETTE 2026 sessions, all available now: https://lnkd.in/eSfZMqSN #PosetteConf
-
LISTEN/NOTIFY is elegant—but NOTIFY grabs a cluster-wide exclusive lock that can cascade into timeouts under high concurrency. Jimmy Angelakos, PostgreSQL Contributor, shares a real-world fix at POSETTE: An Event for Postgres 2026. LISTEN/NOTIFY enables lightweight asynchronous communication between backend components without a separate message bus. In his talk, Jimmy walks through a real-world scenario: a trigger using NOTIFY to alert systems LISTENing for changes made to a high-traffic table. You’ll dive deep into + The problems caused by this scenario + Investigation of the symptoms, and + A solution for fixing the issue in production Also: What you can do to mitigate these risks in your own LISTEN/NOTIFY usage. 📺Watch Jimmy's talk on YouTube: https://lnkd.in/e-HHUz6H #PosetteConf
-
What if you could run analytical queries inside Postgres without an ETL pipeline? At POSETTE: An Event for Postgres 2026, Nitin Jadhav (Microsoft) demos pg_duckdb on Azure Database for PostgreSQL, querying tables & Parquet files from object storage. Many teams build ETL pipelines just to answer questions about data that already lives in Postgres. Nitin walks through what pg_duckdb handles well & where it fits in real-world workflows: + Columnar-style analytical queries inside Postgres without a separate warehouse, sync process, or another system to manage + Not a full data warehouse replacement, but a faster, simpler path to the answers your team needs from the database you already use + Practical tips & real examples you can apply right away 📺See Nitin's talk on YouTube: https://lnkd.in/e3qy82FP #PosetteConf
-
How do you diagnose whether a Postgres bottleneck is CPU, I/O, or network? Rahila Syed walks through iterative profiling with perf & pgbench, showing how bottlenecks shift during optimization at POSETTE: An Event for Postgres 2026. As a practical example, Rahila walks through an optimization in PostgreSQL's physical replication: + Enabling the WAL sender to transmit WAL records to standbys before they are flushed to disk on the primary + Leveraging WAL buffers to send data more proactively, minimizing disk reads & improving network utilization + For large transactions, sending most WAL data in parallel with ongoing writes on the primary to reduce replication lag + Using custom benchmarking scripts tailored to the specific optimization under test to measure real improvement 📺Catch Rahila's talk on YouTube: https://lnkd.in/efsmq-tp #PosetteConf
-
Pavlo Golub of Cybertec shares his talk “pgcov: Bringing Real Test Coverage to PostgreSQL Code” at POSETTE: An Event for Postgres 2026. In Pavlo’s own words: Postgres devs rely heavily on PostgreSQL functions, procedures, and SQL logic, yet largely test them as black boxes. Tests may pass, but we rarely know what actually executed and what code paths remain untested. pgcov proposes a missing piece in the PostgreSQL tooling ecosystem: + coverage analysis for SQL and PL/pgSQL + similar to what go test -cover, or + or pytest --cov provide for application code 📺See Pavlo's talk on YouTube: https://lnkd.in/eDKgxcwK #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. The query planner relies on a mathematical model of your data distribution to make decisions—and when that model is wrong, performance suffers. This session digs into how Postgres "sees" your data: + Histograms, most common values (MCV) & correlation in the pg_stats view + Extended Statistics for fixing bad query plans on correlated columns (like City & State) + How to make sure the planner stops guessing & starts knowing 📺Check out Richard's talk on YouTube: https://lnkd.in/ec97qd7p #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. The WAL enables Postgres features like crash recovery, point-in-time recovery, and binary and logical replication. Bruce is a former teacher who excels at explaining things, and his talk covers: + What is stored in the WAL + How binary & logical replication work under the hood + How replication slots track replication progress 📺Catch Bruce's talk on YouTube: https://lnkd.in/eZs3hfZx #PosetteConf