Online Documentation for SQL Manager for PostgreSQL
Setting analyze parameters
This step of the wizard allows you to specify basic analyze parameters to be applied to the operation.
Reclaim storage occupied by deleted tuples
In normal PostgreSQL operation, tuples that are deleted or obsolete due to an update are not physically removed from their table and therefore remain present. Select this option to perform the VACUUM operation that reclaims storage occupied by deleted and obsolete tuples.
Compact unused space
This option specifies "full" vacuum which may reclaim more space, but takes much longer and exclusively locks the table (FULL).
This option enforces "freezing" of tuples (FREEZE). The option is recommended for read-only databases.
Show detailed operation report
Check this option to receive a detailed vacuum activity report for the table (VERBOSE).
Click the Next button to proceed to the Selecting columns to analyze step of the wizard.