5mins of Postgres E22: Reduce Aurora I/O costs with table partitioning, understand partition pruning
Today, we're going to talk about using partitioning to reduce AWS Aurora I/O costs, pg_partman, and how partition pruning speeds up query performance.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
AWS Blog: Reduce read I/O cost of your Amazon Aurora PostgreSQL database with range partitioning: https://aws.amazon.com/blogs/database...
Yahav Biran on Twitter: / yahavbiran
pg_partman GitHub repo: https://github.com/pgpartman/pg_partman
AWS Docs: Managing PostgreSQL partitions with the pg_partman extension: https://docs.aws.amazon.com/AmazonRDS...
PostgreSQL Docs: Partition Pruning: https://www.postgresql.org/docs/curre...
PostgreSQL 14 out-of-cycle release coming June 16, 2022: https://www.postgresql.org/about/news...
5mins of Postgres E20: An important bug in Postgres 14 with REINDEX / CREATE INDEX CONCURRENTLY, and using the amcheck extension: https://pganalyze.com/blog/5mins-post...
amcheck for Postgres: https://www.postgresql.org/docs/14/am...