[Theorem] Difference between VACUUM and VACUUM FULL

The vacuum of the PostgreSQL system is a routine maintenance process. The differences between VACUUM and VACUUM FULL is as follows :

 

VACUUM	VACUUM FULL
1. It only delets the dead tuples in the table, and there is no real physical deletion; 2. During the vacuum process, the data table can be accessed normaly.	1. Physically delete dead tuples in the table to free up space to the operating system; 2. During vacuum full, the table is locked and access is not allowed.

 

 

Source from : https://pankajconnect.medium.com/vacuum-and-vacuum-full-postgresql-4c9da30a1500