Scale Your Database Game: Dissecting Postgres Partitioning with Bruce Momjian

We're back and better than ever! After a long hiatus, our group is finally holding in-person Meetups again, and we're kicking things off in style. We're thrilled to announce that Bruce Momjian, one of the foremost experts on Postgres, will be leading the charge with a talk on partitioning in Postgres.

Get ready to dive deep into the world of Postgres with Bruce as he dissects partitioning like never before. Declarative partitioning is an essential technique for improving performance and simplifying data management for large datasets, and Bruce will show you the ropes.

This talk explains the purpose and limitations of Postgres's declarative partitioning implementation. It uses SQL queries to illustrate partition performance optimizations and concludes by showing some complicated data architectures made possible by partitioning.