The Fastest Way to Become a Backend Developer Online
AI, Data Science & Cloud Certificates from Google, IBM & Meta
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Dive into a comprehensive conference talk on optimizing autovacuum, PostgreSQL's built-in vacuum cleaner. Learn why vacuum is essential for maintaining database health, when manual vacuuming is preferable, and gain an in-depth understanding of autovacuum's functionality. Explore common misconceptions about autovacuum and discover five key takeaways to improve your PostgreSQL database performance. Benefit from the speaker's decade-long experience working with over 50 Postgres customers, addressing real-world challenges in production environments. Acquire practical knowledge on diagnosing autovacuum issues and implementing effective solutions to manage database bloat in high-volume OLTP workloads.
Syllabus
Introduction.
Why vacuum is essential.
When vacuuming manually works best.
Autovacuum overview.
Autovacuum is not magic.
5 things to remember.
Taught by
Microsoft Developer