Partitioning | Postgres.FM 040 |
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/index-ma...
Timescale partitioning https://docs.timescale.com/use-timesc...
pg_cron https://github.com/citusdata/pg_cron
Xtreme PostgreSQL (talk by Christophe Pettus) • Xtreme PostgreSQL!
Database Antipatterns (also by Christophe, slides 46-49) 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 audio-only podcast episodes, edited for convenient listening.