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

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.

[puru]

This is a very informative and underrated video - good job!

[yp]

Why does it keep dead tuples inside the table in the first place? What is it trying to protect or prevent by keeping old deleted or updated records? What are the advantages?

[pavulurisatish]

I am really searching for your videos when I required to understand any new concept in Postgresql. Your videos are really easy to understand and providing the required information. Thanks a lot. God bless you.