5mins of Postgres E54: The alternative to VACUUM FULL: How to run pg_repack on Amazon RDS and Aurora скачать в хорошем качестве

5mins of Postgres E54: The alternative to VACUUM FULL: How to run pg_repack on Amazon RDS and Aurora

Today, we talk about why you shouldn't use `VACUUM FULL` and how to use the alternative, pg_repack, on Amazon RDS and Aurora. We walk through pg_repack’s benefits, how to install it, and how it helped making one of our tables over 10x smaller. 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   Check out the pganalyze library for eBooks, webinars, and more: https://pganalyze.com/resources 📑 What we have discussed in this episode of 5mins of Postgres: When to use VACUUM FULL - by depesz https://www.depesz.com/2023/02/06/whe... Remove bloat from Amazon Aurora and RDS for PostgreSQL with pg_repack - by Ayushi Gupta and Vibhu Pareek on the AWS blog https://aws.amazon.com/blogs/database... pg_repack 1.4.8 https://reorg.github.io/pg_repack/ PostgreSQL Yum Repository https://yum.postgresql.org/