PostgreSQL Understanding Vacuum 06/12
If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.
Use the link below to get a 60% OFF.
PostgreSQL High-Performance Tuning Guide - Full Course
https://www.udemy.com/course/postgres...
Understanding PostgreSQL Vacuum process is key to performance and administration. Without good vacuuming practices, storage can grow up unreasonably over time. If the system is bloated it will need to perform expensive operations or downtime to fully recover from. Any time you UPDATE or DELETE, you will leave a dead row behind. If you have large tables with excessive dead tuples then performance will tend to decrease. Therefore the postgres VACUUM process should never be avoided.
