On September 22, we will have the privilege of welcoming Devrim Gündüz, Postgres Major Contributor and PGDG RPM Packager. Devrim has presented at our meetup multiple times, and we are always eager to hear more insights on Postgres internals. VACUUM (and REPACK): From your head down to your shoesVACUUM is an essential part of PostgreSQL and got a new friend, REPACK in v19. In this talk, Devrim will go through it, starting from the basics to the internals.– MVCC: The basics– Data snapshots– VACUUM– VACUUM processing– FREEZE– VACUUM tuning– VACUUM FULL– REPACK and its future Agenda 5:20 – doors open5:30…

Join us for an evening of practical PostgreSQL insights on August 26th, featuring two talks that explore modern database engineering and innovative uses of PostgreSQL. The Database Flywheel — Zach Paden, Tech Lead at SymetraLearn how to shift database change testing left and validate schema changes before they reach long-running database instances, bringing database workflows closer to modern CI/CD practices. Can PostgreSQL Reduce Repeated Quantum Computation? — Aayush GaubaExplore how PostgreSQL can act as a persistent cache for computationally expensive quantum simulations, using features such as JSONB, indexing, generated columns, and query optimization to improve performance and reproducibility. Come learn,…

Prairie Postgres is returning to its regular meetup schedule with a two-talk format featuring Zach Paden and Anna Bailliekova. Zach Paden will present Declarative Schema Management with pgschema, a talk focused on simplifying database schema changes. Many application teams struggle with versioning database migrations and maintaining long migration histories. Zach will introduce pgschema, a tool that allows developers to write pure SQL declaratively while automatically deriving valid online migrations. Anna Bailliekova will present PostGIS Quick Start, a beginner-friendly introduction to PostgreSQL’s geospatial capabilities. Using transportation examples, Anna will walk through practical PostGIS features for anyone who has wanted to explore…