POSETTE: An Event for Postgres 2024
2024-06-11..2024-06-13
-- 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 2024 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 11-13 in 2024. 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 subl...
who it's for
postgres DBAs, azure cloud engineers, rails developers, django developers, python developers, postgres extension authors, geospatial engineers
topics
query tuning versus config; prepared statements in poolers; row level security patterns; postgres extension packaging; postgres for AI on Azure; multi-tenant Rails on Postgres; logging and auto_explain; fast bulk import techniques; table partitioning for performance; pgvector and vector search; PostGIS spatial types and KNN; physical replication internals
| title | author | length |
|---|---|---|
| All The Postgres Things at Microsoft, POSETTE edition | Charles Feddersen | 24m |
Microsoft reports 353 commits to Postgres in the last year with 27% made on behalf of others and contributions to Patroni, PgBouncer and pgcopydb; Postgres 17… | ||
| Tuning Parameters in Postgres vs. Tuning Your Queries | Henrietta Dombrovskaya | 18m |
Compares changing Postgres configuration versus fixing queries using the postgres_air sample database and live timings: with defaults the query runs ~2.5s… | ||
| Comparing Postgres connection pooler support for prepared statements | Jelte Fennema-Nio | 23m |
Postgres poolers PgBouncer, Odyssey, pgcat and Supavisor now support prepared statements but with different designs and tradeoffs: Odyssey remaps client names… | ||
| Everything you need to know about Postgres Row Level Security | Paul Copplestone | 18m |
Concrete how-to plus performance rules for Postgres Row Level Security: enable RLS on tables by running ALTER TABLE ... ENABLE ROW LEVEL SECURITY and create… | ||
| Open Source Contributions to Postgres: The Basics | Elizabeth Garrett Christensen | 27m |
A concrete how-to showing a real documentation patch that actually gets committed, explaining why the HOT updates docs needed clarifying about BRIN interaction… | ||
| Postgres-powered AI: Running an End-to-End AI Platform with Postgres on Azure | Jaehyn Sim | 24m |
An end-to-end AI platform built on Postgres uses Postgres JSON fields for heterogeneous metadata, leverages ACID concurrency to avoid bespoke locking, and… | ||
| SaaS on Rails on PostgreSQL | Andrew Atkinson | 25m |
Covers concrete recipes for multi-tenant Rails on PostgreSQL using a sample Rideshare app: add company_id to rows, optional composite PKs (Active Record 7.1)… | ||
| What Enterprises like about Azure Database for PostgreSQL - Flexible Server | Kanchan Bharati | 26m |
Claims a 62% on-prem to Azure cost reduction and up to 84% with modernization, with storage reaching Premium SSDv2 (4.5× faster, up to 64 TB, 80k IOPS and 1200… | ||
| Scaling the Wall of Text: Logging Best Practices in PostgreSQL | Richard Yen | 28m |
PostgreSQL logging must be configured: set log_line_prefix to include timestamp, PID, session/tx id, user, DB and client so you can trace who did what; use… | ||
| Making Postgres inserts faster on Azure | Gayathri Paderla | 18m |
Practical recipes and numbers: using unlogged tables gives about 5× faster inserts and 10× faster COPY for staging loads; switch heavy imports to the COPY… | ||
| State of the Postgres Extension Ecosystem | David Wheeler | 26m |
Postgres extensions remain scattered but momentum is clear: PGXN hosts ~400 extensions (369 distributions) while community inventories list ~1,200 public… | ||
| The Open Source Geospatial Community, PostGIS, & Postgres | Regina Obe | 21m |
PostGIS originates in 2001 origin as a Postgres extension and claims to make spatial data “not special” by exposing geometry, geography, raster and topology… | ||
| Vector data in Postgres - how's it different from "normal" data? | Heikki Linnakangas | 25m |
Postgres stores vectors as arrays of 32-bit floats (OpenAI models use 1536 dims → ~6 KB per vector), so indexes must fit in RAM and HNSW index build runs… | ||
| From Postgres full text search to Retrieval Augmented Generative search | Adam Wolk | 22m |
A Rails demo builds an email chatbot called Milly the Mailiphant that progresses from Postgres LIKE to full text search with a GENERATED tsvector column and… | ||
| Lessons Learned from benchmarking and profiling distributed PostgreSQL | Lotte Felius | 24m |
Used the Citus Benchmark Suite plus YCSB via JDBC to run 100 million-record tests with 100% INSERT (workload A) and 100% SELECT (workload C). INSERT throughput… | ||
| Data-intensive PostgreSQL: Three ways to scale | Marco Slot | 25m |
Explains three concrete scaling patterns with tools and tradeoffs: for multi‑tenant SaaS use schema-based sharding or row‑per‑tenant to keep per‑tenant ops… | ||
| HA and DR at a glance with Azure Database for PostgreSQL | Silvano Coriani | 28m |
Demonstrates Azure Database for PostgreSQL configuring zone-redundant HA with synchronous local replication (near-zero RPO) and asynchronous multi-region DR… | ||
| Even JSONB In Postgres Needs Schemas | Chris Ellis | 23m |
Postgres stores JSON efficiently with JsonB but still needs enforced shapes: uses GIN indexes for fast contains queries, jsonb_typeof to assert root types, and… | ||
| Postgres Storytelling: What's going on with Synchronous Replication? | Boriss Mejias | 25m |
Synchronous commits pile up because massive VACUUM activity on a 18 TB table produces huge volumes of WAL, trips max_wal_size and forces checkpoints so… | ||
| How to work with other people | Floor Drees, Jimmy Angelakos | 28m |
Explains concrete numbers — 15–20% of people are neurodivergent, ~10% dyslexic, ~5% ADHD, 1–2% autistic and only 29% of autistic people hold full‑time jobs —… | ||
| Accelerating PL/pgSQL Code Conversation When Migrating to Postgres | Deepak Mahto | 22m |
Code conversion consumes about 50% of migration effort and the talk lays out concrete accelerators: use plpgsql_check to surface runtime errors before… | ||
| PostgreSQL Partitioning: Slicing and Dicing for Performance and Easier Maintenance | Ryan Booz | 30m |
PostgreSQL declarative partitioning claims faster queries and easier maintenance by making partitions ordinary child tables that can be dropped or detached for… | ||
| Why I love open source development & what I learned from K8s | Sarah Novotny | 21m |
Kubernetes experience leads to concrete practices: treat contributions as ownership, plan succession so projects outlive individuals, and use mailing lists… | ||
| Beyond Joins and Indexes | Bruce Momjian | 26m |
Explains that the Postgres optimizer actually chooses 43 different plan-node strategies beyond simple joins and indexes, shows the exact SQL and EXPLAIN output… | ||
| Tales from the Field - Oracle to PostgreSQL migrations | Adithya Kumaranchath | 29m |
Enterprise migrations from Oracle to Postgres use concrete tactics: a trading app handling 1 million messages per minute migrates with phased pipelines and a… | ||
| pgvector for Python developers | Pamela Fox | 27m |
Shows how to install the pgvector extension (the extension is actually called vector), create a vector column and use psycopg, asyncpg, SQLAlchemy/SQLModel and… | ||
| PostgreSQL physical replication - internals, latest development and opportunities | Krishnakumar R, Melih Mutlu | 24m |
Primary and standby exchange WAL via WalSender and WAL receiver; WalSender reads WAL from disk and startup applies WAL files on standby. Recent changes: PG15… | ||
| Using Azure Query Store to Understand PostgreSQL Performance | Grant Fritchey | 26m |
Query Store for Azure Database for PostgreSQL records aggregated query stats, wait stats and multiple explain plans into one‑hour segments (default retention 7… | ||
| How/Why to Sweep Async Tasks Under a Postgres Table | Taylor Troesh | 19m |
Shows a concrete pattern: store tasks in a Postgres table and have a simple worker loop that runs a transaction, SELECT ... FOR UPDATE SKIP LOCKED a single… | ||
| 6 things you can do with azure_ai & PostgreSQL on Azure | Denzil Ribeiro | 27m |
Shows concrete steps to add vector search and AI to Azure Database for PostgreSQL using the azure_ai and azure_local_ai extensions plus pgvector, with SQL UDFs… | ||
| Revitalizing Outdated Data Models with PostgreSQL Views | Newvick Lee | 24m |
Claims that PostgreSQL Views can modernize a messy polymorphic schema without migrations, using only views plus optional triggers and parameters. Demonstrates… | ||
| What makes Azure Database for PostgreSQL Great for Developers? | VARUN DHAWAN | 32m |
Azure Database for PostgreSQL Flexible Server lists 8 developer-focused features: managed ops so teams focus on code, tunable server parameters and Query Store… | ||
| A Walking Tour of PostgreSQL | Thomas Munro | 21m |
Postgres traces back to the POSTGRES research project, becomes the SQL-based open source system from 1996, and evolves through concrete engineering: 400–500… | ||
| Partitioning your Postgres tables for 20x better performance | Derk van Veen | 26m |
Shows converting inheritance-based partitions to native partitioning, adding check constraints and denormalising ledger joins so everything partitions by… | ||
| Where do the performance cliffs come from? | Tomáš Vondra | 26m |
Explains why Postgres produces abrupt slowdowns with concrete numbers: a hard-coded hash-table threshold at 9 values makes removing one IN element double… | ||
| Hazards of logical decoding in PostgreSQL | Polina Bungina | 22m |
Explains why logical decoding can blow up disk and CPU: every slot spawns a WalSender that decodes the shared pg_wal stream single‑threaded, uses work_mem and… | ||
| PostgreSQL performance tips you have never seen before V2.0 | Hans-Jürgen Schönig | 26m |
PostgreSQL tips that change actual numbers: loading PL/R/PostGIS into shared_preload_libraries cuts first-call latency from ~229 ms to under 1 ms and speeds… | ||
| Autotuning PostgreSQL on Azure Flexible Server | Luigi Nardi | 28m |
Autotuning system built around DBtune open source agent connects to Azure Flexible Server via Azure CLI and Azure Monitor, iteratively changes pgconf, observes… | ||
| You Don't Need a Database Backup Policy | Karen Jex | 29m |
Claim: a backup policy alone is useless unless it’s driven by recovery requirements. Define RPO, RTO and retention, then pick methods that meet them: physical… | ||
| Advancing Drug Search with PostgreSQL and Azure AI | Taras Kloba | 28m |
Built a mobile drug‑search app in 5 days that wins the TIDE NATO Hackathon and gets a grant, using PostgreSQL with the azure_ai extension to store vectors and… | ||
| Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability | Federico Campoli | 25m |
Real-world GCP tests use Rocky Linux 9.3, PostgreSQL 16.2 on an e2-highmem-8 with separate SSD volumes and pgbench: pgbench sf500 with 50 clients for 120s… | ||
| Semantic search with Django, PostgreSQL, & pgvector | Paolo Melchiorre | 25m |
Shows a working semantic search added to an existing Django app by storing embeddings in Postgres via pgvector, creating a Vector extension migration and a… | ||
| nothing matches | ||