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.

 

Analyze & Vacuum Table - Setting analyze parameters

 

CheckBox 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.

 

CheckBox Compact unused space

This option specifies "full" vacuum which may reclaim more space, but takes much longer and exclusively locks the table (FULL).

 

CheckBox Freeze tuples

This option enforces "freezing" of tuples (FREEZE). The option is recommended for read-only databases.

 

CheckBox 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.