![Advanced Autovacuum Tuning and pganalyze VACUUM advisor - Webinar Cover Image](/static/34d3eef64765e40966fb212572eac704/42e2a/advanced-autovacuum-tuning_sml.png)
Webinar: Advanced Autovacuum Tuning and pganalyze VACUUM advisor
Understand the most important VACUUM metrics, concepts like xmin horizon, how to prevent transaction ID wraparound, estimating bloat, and more.
Lukas Fittl
Founder & CEO, pganalyze
Founder & CEO, pganalyze
In detail, we walk through
- How to identify ineffective VACUUMs that run but don’t actually produce any results
- Tracking freezing stats to prevent TXID wraparound, and how to find problem tables
- The VACUUM xmin horizon, and how it causes “Dead Tuples Not Yet Removable”, and how pganalyze alerts you of this situation
- Why BUFFERS is important, and how to interpret the hits counter
- How pganalyze calculates the age of transaction IDs using calendar time (not just counting TXIDs)
- How pganalyze estimates bloat, and when the estimates are more vs less accurate
- The new logic for scale factor and threshold tuning recommendations, and how it works behind the scenes
- How VACUUMs that have multiple index phases can use a lot of resources, and how pganalyze recommends changing autovacuum_work_mem to avoid the problem
- The pganalyze VACUUM Advisor
Watch the Webinar Recording
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
![Atlassian](/static/e2f030cddae3e00fc03bf3741b0de8cd/c2dfb/atlassian.png)
![DoorDash](/static/8e5c810a239a71c0c7c50dac21a8fff6/865c7/doordash.png)
![Moody's](/static/88824cdf6cf338e2528a766568f5aa60/fa0cd/moodys.png)
![fuboTv](/static/b4f541a54e2a187f4998da33e565b128/6245d/fubotv.png)
![SeniorLink](/static/37b9ca7eb397a1b1e90fa572cc5a118d/87a86/seniorlink.png)
![Salsify](/static/f26b06c796059745dd6a754a7402d318/3113b/salsify.png)
![CounterPath](/static/b0e2168929c9424b79774cd10d82d2be/95457/counterpath.png)
![Ipsy](/static/f83dc5ca2d428921e410a1ef66258cb3/42891/ipsy_white.png)