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 docs https://www.postgresql.org/docs/curre...
* pg_partman https://github.com/pgpartman/pg_partman
* Index maintenance episode https://postgres.fm/episodes/indexma...
* Timescale partitioning https://docs.timescale.com/usetimesc...
* pg_cron https://github.com/citusdata/pg_cron
* Xtreme PostgreSQL (talk by Christophe Pettus)    • Xtreme PostgreSQL!  
* Database Antipatterns (also by Christophe, slides 4649) https://thebuild.com/presentations/an...
* Understanding an outage (blog post by Duffel) https://duffel.com/blog/understanding...

~~~

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  

~~~

Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

~~~

This is the uncut version, with video. Check out https://Postgres.fm to find audioonly podcast episodes, edited for convenient listening.