Search – talk-data.com

Title & Speakers	Event
Breaking Up with Massive Tables via Partitioning 2026-01-14 · 23:00 We'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.com	Breaking Up with Massive Tables via Partitioning

We'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.com

Activities & events