Partitioning - Postgres FM

What this episode covers

Nikolay and Michael discuss table partitioning — what it is, why and when it's helpful, and some considerations for your partition key. Here are links to a few things we mentioned: Partitioning docspg_partmanIndex maintenance episode Timescale partitioningpg_cronXtreme PostgreSQL (talk by Christophe Pettus)Database Antipatterns (also by Christophe, slides 46-49)Understanding an outage (blog post by Duffel)~~~What did you like or not like? What should we discuss next time? Let us know on social media, or by commenting on our Google doc.If you would like to share this episode, here's a good link (and thank you!)~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork

Share this episode

Similar Episodes

November 30, 2025 - Unity through Service: A conversation with ACAO executive officer Hector Addison

Dec 12, 2025 ·23m

November 27, 2025 - A conversation with UOSU's President Jack Coen

Dec 4, 2025 ·32m

October 30, 2025 - AI: Yay or Nay?

Nov 8, 2025 ·36m

October 16, 2025 - Why are fewer young men enrolling in post-secondary education?

Oct 16, 2025 ·34m

October 2, 2025 - Chrystia Freeland resigns from cabinet and is appointed to new Ukraine envoy role

Oct 5, 2025 ·25m

September 18, 2025 - How Labubus took over your feed

Sep 18, 2025 ·26m

Similar Podcasts

Frag Big Moes Mama 98.8 KISS FM Big Moes Mama ist genauso crazy wie ihr Sohn und ab sofort part of the podcast family! Ab jetzt jeden Dienstag ab 22 Uhr auf KISS FM in der Podcast Happy Hour: Frag Big Moe’s Mama! Big Moe und seine Mama beantworten gemeinsam alle möglichen Fragen aus der KISS Nation. Jedes Thema ist willkommen. Natürlich nutzt Big Moe’s Mama jede Möglichkeit, um diverse peinliche Geschichten aus Big Moe’s Leben zu erzählen! Was für Big Moe auch mal sehr unangenehm werden kann. Tune in! Behind The X 102.5 KNIX (KNIX-FM) An all access pass to Arizona's #1 Country station. Hear the behind-the-scenes content and interviews from 102.5 KNIX! HealthCall LIVE WOWO / Federated Media HealthCall LIVE with Lee Kelso is a summary of the weeks most interesting and useful health and medical news. Lee Kelso is a veteran TV news anchor, radio journalist and host of viewer-driven, health-focused TV and online broadcasts. Each week, he brings you a series of interesting health news headlines and medical breakthroughs collected from professional journals and research projects around the world. You can also listen to HealthCall LIVE at 7am Tuesday mornings and 9-10am Saturday mornings on News/Talk 1190 WOWO 107.5 FM in Fort Wayne. The Math Factor C Goodman-Strauss Kyle Kellams A brief, weekly math conversation and puzzle, airing on KUAF 91.3 FM, Fayetteville Arkansas. Send your answers, comments, questions, puzzles, or cash, to [email protected]!

Frequently Asked Questions

How long is this episode of Postgres FM?

This episode is 34 minutes long.

When was this Postgres FM episode published?

This episode was published on April 7, 2023.

What is this episode about?

Nikolay and Michael discuss table partitioning — what it is, why and when it's helpful, and some considerations for your partition key. Here are links to a few things we mentioned: Partitioning docspg_partmanIndex maintenance episode Timescale...

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this Postgres FM episode?

Yes, you can download this episode by clicking the download button on the episode player, or subscribe to the podcast in your preferred podcast app for automatic downloads.