POSETTE: An Event for Postgres 2025
2025-06-10..2025-06-12
-- online --
[POSETTE: An Event for Postgres 2024, POSETTE: An Event for Postgres 2025, POSETTE: An Event for Postgres 2026]
as the organisers put it
POSETTE 2025 is a wrap, but you can still watch all the talks! POSETTE: An Event for Postgres is a virtual and free developer event that happened on June 10-12 in 2025. Watch any or all of the 42 talks to learn what you can do with the world’s most advanced open source relational database—from the nerdy to the subli...
who it's for
postgres developers and operators, cloud engineers managing Azure Database for PostgreSQL, data engineers and analytics architects, backend web developers (Python and .NET), extension and tooling developers (Rust, pgrx), database security and compliance engineers, site reliability engineers
topics
Postgres 18 planner and I/O improvements; Azure Database for PostgreSQL features; pgvector embeddings and RAG; DiskANN HNSW IVFFlat indexes; EXPLAIN (ANALYZE, BUFFERS) query tuning; table partitioning and partition performance; logical replication and replication theory; incremental backup and PITR strategies; pgx/pgrx Rust extension development; DuckDB integration for analytics (pg_duckdb); full-text search via Tantivy in Postgres; row-level security in distributed Postgres (Citus)
| title | author | length |
|---|---|---|
| What Microsoft is Building for Postgres in 2025 | Charles Feddersen | 21m |
Microsoft reports 456 pre-release commits to Postgres 18 and adds true asynchronous I/O, planner and hash-join speedups, a vacuum I/O reduction, and a… | ||
| Databases in the AI Trenches | Bruce Momjian | 26m |
Describes embedding workflow: chunk text, fetch OpenAI embeddings, average token vectors, store them in Postgres (example uses pgvector), then run… | ||
| Azure Database for PostgreSQL: 15 Essential Standards for Compliance and Security | Taiob Ali | 27m |
Practical checklist of 15 standards for Azure Database for PostgreSQL with concrete settings and enforcement paths: mandatory Private Endpoints, choose Entra… | ||
| Best Practices for Tuning Slow Postgres Queries | Lukas Fittl | 23m |
Practical walkthrough of diagnosing slow Postgres queries using real outputs and concrete fixes: how to benchmark with EXPLAIN (ANALYZE, BUFFERS), how… | ||
| Building a PostgreSQL data warehouse | Marco Slot | 27m |
Describes a production system that turns Postgres into a lakehouse by adding extensions that write Iceberg metadata and Parquet files to blob storage, use… | ||
| Building Enterprise RAG with Azure Database for PostgreSQL and pgvector | Michael John “MJ” Pena | 20m |
Shows a working RAG stack on Azure Database for PostgreSQL using the pgvector extension, the create_embeddings wrapper tied to Azure OpenAI, and SQL functions… | ||
| Building Intelligent Applications with Graph-Based RAG on PostgreSQL | Abe Omorogbe | 21m |
Demonstrates a legal Copilot built in Postgres on a Washington subset of the US Caselaw dataset (~100k cases, ~500k pages), converting opinions to embeddings… | ||
| Building modern Python web apps with PostgreSQL | Pamela Fox | 30m |
Claims Postgres is the most popular DB among Python devs and demonstrates a working API‑centric stack: FastAPI + asyncpg + SQLAlchemy using ASGI/asyncio for… | ||
| Can We Use Rust to Develop Extensions for PostgreSQL? | Shinya Kato | 26m |
Claim: Rust can build real PostgreSQL extensions using the pgrx framework, and the demo extension compiles, installs, and its unit test passes across supported… | ||
| Dear Azure Database for PostgreSQL, can you automate my index? | Nacho Alonso Portillo | 28m |
Azure Database for PostgreSQL Flexible Server claims to auto-tune indexes by scanning Query Store and emitting create index and drop index recommendations… | ||
| Debugging Data Corruption in PostgreSQL: A Systematic Approach | Palak Chaturvedi, Nitin (mentioned) | 32m |
A systematic debugging framework walks through concrete steps: validate pg_controldata, run pg_waldump on the WAL named by the last checkpoint, use… | ||
| Designing a monitoring feature in PostgreSQL | Rahila Syed | 25m |
Implements pg_get_process_memory_contexts(pid, get_summary, timeout) to fetch on‑demand per‑process memory context stats by sending a signal and waiting on a… | ||
| Designing for Document Databases in PostgreSQL | Vinod Sridharan | 26m |
DocumentDB is built as a PostgreSQL extension that removes SQL text translation by using the planner hook to feed aggregation pipelines directly to Postgres… | ||
| Elasticsearch-Quality Full-Text Search in Postgres via Tantivy | Philippe Noel | 28m |
Demonstrates a Postgres extension, pg_search, that embeds the Tantivy search engine (built in Rust with pgrx) to add BM25 scoring, richer tokenization, fast… | ||
| Exploring .NET & PostgreSQL on Linux as your OSS app dev stack | Silvano Coriani | 34m |
Demo shows installing .NET on a Debian ARM64 VM, building and running a console app and container images for ARM64 and AMD64 images, pushing one to Azure… | ||
| Fortifying Azure Database for PostgreSQL: Stop Intrusions in Their Tracks | Johannes Schuetzner | 29m |
Covers concrete steps to lock down Azure Database for PostgreSQL: enable private endpoint (Feb 2024) to route traffic over the Azure backbone (multiple… | ||
| From MongoDB to Postgres: Building an Open Standard for Document Databases | Peter Farkas | 32m |
MongoDB’s 2018 switch to SSPL creates vendor lock-in; a 67K-developer StackOverflow survey still shows Postgres as the most wanted DB. The claim: run MongoDB… | ||
| Fun With UUIDs | Chris Ellis | 24m |
Explains that random UUIDs (v4) cause index churn via Postgres free space map and index-only scans, shows a buffer-count blowup versus sequential keys, and… | ||
| Hacking Postgres Executor For Performance | Amit Langote | 32m |
Postgres executor changes that are already committed and measurable: expression evaluation moves from tree-walking to an opcode-based execution loop yielding… | ||
| Implementing Strict Serializability with pg_xact | Jimmy Zelinskie | 27m |
Shows a practical way to get Strict Serializability from Postgres by using pg_xact metadata functions to record server-assigned transaction IDs and snapshots… | ||
| Incremental Backup in PostgreSQL | Robert Haas | 18m |
Feature targets very large databases by copying only changed blocks to cut backup time and size, claiming up to avoiding hundreds of gigabytes or terabytes of… | ||
| Introducing Microsoft's VS Code Extension for PostgreSQL | Matt McFarland | 18m |
New VS Code extension claims a full Postgres workflow inside the editor: manage connections, browse objects, run queries with schema-aware autocomplete, and… | ||
| Leveraging table partitioning for query performance and data archiving | Derk van Veen | 27m |
Starts recommending range partitioning once tables reach ~100 GB, claiming maintenance and query wins up to 50x faster after aligning partitions around a… | ||
| Logical replication theory and concepts | Ashutosh Bapat | 29m |
Explains how PostgreSQL converts WAL bytes into row-level operations using a reorder buffer and logical decoder, sends only committed transactions, and applies… | ||
| Managing Postgres at scale: Challenges, Tools & Techniques | Karen Jex | 30m |
Defines "at scale" as tens of terabytes or hundreds-to-thousands of databases and lists concrete fixes: use partitioning to drop a year partition instead of… | ||
| Migrating from Oracle to Azure Database for PostgreSQL, Seamlessly | Neeta Goel, Sandeep Rajeev | 24m |
Claims a 4x speedup—moving projects from 12 months to 12 weeks—by combining an AI engine called DMAP with a process wrapper, the CMC Framework. Shows… | ||
| Myths and Truths about Synchronous Replication in PostgreSQL | Alexander Kukushkin | 26m |
Explains WAL-based physical streaming vs log-shipping, exact effects of synchronous_commit (on, remote_write, remote_apply) and synchronous_standby_names… | ||
| Neon: How we made PostgreSQL serverless | Heikki Linnakangas | 26m |
Neon offers PostgreSQL as a serverless service by splitting Postgres into a stateless compute layer and a multi-tenant storage service that serves 8KB pages… | ||
| Overcoming Performance Hurdles in Postgres Partitioned Tables | Sarat Balijepalli | 30m |
Experiments on Azure Postgres (PG17) show planning time rising from milliseconds to ~10s as partitions grow to 5000+ partitions (10,000 in one test) while… | ||
| Performance Archaeology - 20 years of improvements | Tomáš Vondra | 29m |
Benchmarks run pgbench (Postgres 18 client) and TPC-H on two machines (44‑core/88‑thread for OLTP, SSD small server for OLAP) comparing releases from 8.0→18.0… | ||
| pg_duckdb: Ducking awesome analytics in Postgres | Jelte Fennema-Nio | 24m |
pg_duckdb embeds DuckDB inside Postgres so analytics run with DuckDB’s columnar engine, multithreading and Parquet/S3/Azure I/O instead of Postgres’ row scans… | ||
| Hitchhiker's Guide to Row-Level Security in Citus | Adam Wolk | 28m |
Shows how Postgres RLS behaves in real Citus clusters: enabling RLS, FORCE ROW LEVEL SECURITY to stop owner bypass, and that superusers or roles with bypass… | ||
| Postgres Storytelling: Cunning Schema Design with Creative Data Modeling | Evelyn Kates, Monica DeBea | 28m |
Designs a Postgres schema for a chess tournament: creates a chess schema, chess.players with serial primary key and case-insensitive unique name via CREATE… | ||
| PostgreSQL and Linux Kernel interactions | Krishnakumar R | 30m |
Shows how PostgreSQL actually calls the kernel: process forks use clone to spawn workers, shared memory uses mmap MAP_SHARED, and signals implement latch… | ||
| Resource Control Admission - I have a date with my PSI | Cédric Villemain | 26m |
Pressure Stall Information (PSI) exposes microsecond counters and 50 ms samples for CPU IO and memory so you can detect stalls rather than wait for loadavg… | ||
| Scaling Postgres to the next level at OpenAI | Bohan Zhang | 25m |
OpenAI runs an unsharded Azure Database for PostgreSQL primary with many read replicas and migrates write-heavy workloads off-system, using PgBouncer to avoid… | ||
| Securing Postgres with streaming replication | Jan Karremans | 22m |
Covers concrete setup steps: enable WAL (write-ahead logging), add a replica, and choose async vs sync with the recommended pattern of local synchronous and… | ||
| Setting max_connection: Building PostgreSQL user groups that bring people together | Ellyne Phneah | 27m |
Malmö Postgres User Group (M-PUG) launches, gains 120 Meetup members and runs six meetups in five months, first event drawing 45 attendees and typical turnout… | ||
| What’s new in the Postgres 18 query planner / optimizer | David Rowley | 28m |
PostgreSQL 18’s planner adds concrete changes: OR->IN conversion turns long OR lists into an index-friendly equals-any index scan; self-join elimination… | ||
| What’s New with Azure Database for PostgreSQL- Flexible Server | VARUN DHAWAN | 25m |
Concrete 2025 feature rundown with numbers and tradeoffs: SSDv2 64 TB / 1,200 MB/s / 80k IOPS plus storage autogrow, near‑zero downtime scaling by VM swap… | ||
| What is Patroni, really? | Polina Bungina | 22m |
Patroni uses an external distributed key‑value store (etcd, Consul, ZooKeeper, Kubernetes control‑plane) to serialize leader elections via atomic… | ||
| Boosting Azure Database for PostgreSQL Performance with Azure Advisor | Gayathri Paderla | 27m |
Shows how Azure Advisor plus alerts and action groups detects and fixes real PostgreSQL failures on Azure Database for PostgreSQL - Flexible Server: set up an… | ||
| nothing matches | ||