This upcoming talk by Steven Zelaznik is a joint event hosted by Prairie Postgres and RubyChicago. The Multi-Terabyte Trust Exercise: Validating Massive Postgres MigrationsMoving a self-hosted Postgres instance to a managed service like Azure is more than a data transfer—it’s a high-stakes mission where “spot-checking” simply won’t cut it. When downtime is limited and a risk-averse client demands absolute proof of data integrity, you can’t rely on luck. This talk tells the story of migrating a multi-terabyte database with millions of rows by building a custom, Ruby-orchestrated validation framework. We’ll move beyond simple row counts to explore how we used…

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,…