# Dynamic Table Partitioning in Postgres

DevFeed: [Dynamic Table Partitioning in Postgres](<https://devfeed.tech/articles/dynamic-table-partitioning-in-postgres-500.md>)

Original publisher: [Read original article](<https://supabase.com/blog/postgres-dynamic-table-partitioning>)

Author: Michel Pelletier

Published: 2023-10-03T07:00:00Z

Content type: tutorial

Language: en

Sources: [Supabase Blog](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Deadlock](<https://devfeed.tech/topics/deadlock.md>)

Tags: [concurrency](<https://devfeed.tech/tags/concurrency.md>), [data](<https://devfeed.tech/tags/data.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [learn](<https://devfeed.tech/tags/learn.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [scale](<https://devfeed.tech/tags/scale.md>)

## AI overview

This article explains how dynamic table partitioning can help scale a large Postgres table in place. Using a customer example with 500 million chat messages, it describes how growing indexes, aging data, unrelated rows, vacuuming, and data movement can degrade query performance and complicate migration without downtime.

## Source excerpt

Learn how to scale large postgres tables in place and increase query performance.