Online Documentation for SQL Manager for PostgreSQL

Setting vacuum parameters


This step of the wizard allows you to specify basic vacuum parameters to be applied to the VACUUM operation.

 

Vacuum Tables - Setting vacuum parameters

 

 

CheckBox Show detailed operation report

Check this option to receive a detailed vacuum activity report for each table (VERBOSE).

 

CheckBox Update optimization statistics

This option updates statistics used by the optimizer to determine the most efficient way to execute a query (ANALYZE).

 

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). This option is recommended for read-only databases.

 

 

Click the Next button to proceed to the Selecting tables step of the wizard.