VACUUM vs VACUUM FULL in PostgreSQL

VACUUM VACUUM FULL
VACUUM simply reclaims space and makes it available for re-use. However, extra space is not returned to the operating system. It’s just kept available for re-us.e within the same table VACUUM FULL rewrites the entire contents of the table into a new disk file with no extra space, allowing unused space to be returned to the operating system
This is faster This is slower
Exlcusive lock not required VACUUM Full requires exclusive on each tables while it is being processed


Syntax:

VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table_name ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table_name [ (column_name [, ...] ) ] ]

Related Posts

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: