What is difference between vacuum and vacuum full in Greenplum?

The gadget spec URL could not be found
Note:
The gadget spec URL could not be found
 Vacuum Vacuum full
Vacuum reclaims dead space and make it available for reuse by the same object / table etc.Vacuum full writes the entire content of the table into new disk file and release the wasted space back to OS , so this cause a table level lock on the table and its much slower , should be avoided on a high load system.
Vacuum update the FSM ( i.e free space management ) and keep tracks of the free space , and subsequent updates on that relation will track the FSM through the internal table and uses them when neededVacuum full writes the entire content of the table into new disk file and release the wasted space back to OS
 Does not lock the table Lock the table
 Greenplum recommend to run vacuum on tables on a regular basis Greenplum recommend not to use vacuum full instead use other reorg table to reclaim the dead tuple space

The gadget spec URL could not be found

The gadget spec URL could not be found

The gadget spec URL could not be found


Comments