Mini updates from our team
-
Become a PG_STATS_* with Sami Imseih
Can you believe we are at the last meetup of 2026?! I can hardly believe it, but that’s true! On November 17, we are closing our 2026 season, and we hope for a grand finale! Our program includes a replay of one of the best PG DATA 2026 talks, an overview of PG Conf.EU and Prairie Postgres’ second birthday celebration! Speaker: Sami Imseih, Senior Software Development Engineer, AWSTalk title: Become a PG_STAT_* (Star)Talk abstract:This talk explores PostgreSQL’s built-in statistics collection system, focusing on the powerful pg_stat_* views. You will learn how to use these views to gain insights into I/O…
Posted:
-
ChicagoRuby x Prairie Postges @ Deinde Financial
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…
Posted:
-
All About vacuum with Devrim Gündüz
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…
Posted:
-
August Meetup -PostgreSQL Meets Django!
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,…
Posted:
-
July 15 Meetup: pgschema and PostGIS
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…
Posted:
-
Declarative Schema Management and PostGIS Quick Start
On July 15, join us for an evening with Zach Paden and Anna Bailliekova, covering schema management with PostgreSQL and a beginner-friendly introduction to PostGIS. Talk 1: Declarative Schema Management with pgschema Speaker: Zach Paden Lots of application developers struggle to understand the concept of versioning database migrations, and managing the history of these migrations can become difficult even with existing tools. In this talk, Zach will introduce pgschema, a tool that allows you to write pure SQL declaratively and lets pgschema derive a series of valid online migrations. Zach Paden is a tech lead at Symetra with experience ranging…
Posted:
-
PGDATA 2026 Conference
PG DATA 2026 was a two-day, community-driven PostgreSQL and data conference held in downtown Chicago. The event brought together developers, database administrators, data engineers, architects, researchers, and open-source professionals for practical technical sessions, expert insights, and community networking. The conference featured presentations on PostgreSQL, database administration, performance optimization, data engineering, cloud infrastructure, artificial intelligence, analytics, and modern data architectures. Attendees had opportunities to learn from experienced speakers, discuss real-world challenges, and connect with members of the PostgreSQL and broader data community. Event Details Date: June 4–5, 2026 Time: Full-day conference Location: Loyola University Water Tower Campus, Chicago, Illinois Venue: Kasbeer…
Posted:
Whether you want to lend a hand or just stay in the loop — we’ve got a spot for you.