What we’re about
NYC Postgres is the largest Postgres-focused meetup in the world. We actively connect people who want to learn and grow with Postgres and Postgres related technologies, products and services.
Upcoming events
2
Breaking Up with Massive Tables via Partitioning
Datadog, New York Times Bldg, 620 8th Avenue, 45th Floor, New York, NY, USWe're excited to host the first 2026 NYC PostgreSQL User Group Meetup on January 14, 2026!
Agenda:
6p - 6:30p: Food & Networking
6:30p - 7:30p: Talk - Breaking Up with Massive Tables via Partitioning
Location: DataDog office, New York Times Bldg, 620 8th Ave, New York, NY 10018
Talk: Breaking Up with Massive Tables via Partitioning
Similar to memory configurations and Active-Active, when you find yourself Googling "How to partition a Postgres table", you're usually in a tight spot. However, although real-life use cases for partitioning typically start with a large, production table where uptime is critical, most documentation and blogs only cover setting up new partitioned tables -- ignoring the delicate work necessary to migrate safely with minimal downtime.
This talk actionably addresses that knowledge gap: covering multiple ways to partition large, production tables.
This talk will discuss:
- Basic Postgres partitioning internals
- Choosing between partitioning strategies (with examples)
- Rules of thumb, and when NOT to partition
- Methods of migrating a live, production table to a partitioned table (with examples and demo code)
- Partitioning observability and maintenance
Speaker: Chelsea Dole
Chelsea Dole is a Database Engineer at a hedge fund with expertise in Postgres and database platform building. Before her current role, she worked in the startup world (most recently at Brex).
She is an active speaker in the Postgres community and has delivered talks across the US, Europe, and Asia. Chelsea also serves as an organizer for PostgresConf NYC.
She got her start as a DBA being “thrown in the deep end”, and seeks to present practical internals talks which speak to engineers in the grey area between “infra engineer” and “database person”.
To get in touch, check out her website: www.chelseadole.com38 attendees
Past events
153
