Partitioning | Postgres.FM 040 | скачать в хорошем качестве

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.