5mins of Postgres E12: The basics of tuning VACUUM and autovacuum in Postgres
In episode 12, we talk about tidying up with VACUUM. We look at autovacuum_vacuum_cost_delay, autovacuum_max_workers, autovacuum_vacuum_scale_factor, autovacuum_vacuum_threshold, autovacuum_freeze_max_age, and more
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:
PG Phriday: Tidying Up With VACUUM: https://www.enterprisedb.com/blog/pg-...
Shaun Thomas on Twitter: / bonesmoses
5mins of Postgres E7: Autovacuum, dead tuples not yet removable, and the Postgres xmin horizon: https://pganalyze.com/blog/5mins-post...