39.7. Vacuuming a Table #
The VACUUM SQL command is executed when vacuuming.
To vacuum a table:
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
Click the name of the database.
Click the name of the schema.
Click
→ Vacuum next to the table. Specify the vacuum parameters (parameters marked with an asterisk are required):
Modes: The vacuum modes.
Possible values:
Analyze: Updates the statistics that the planner uses for selecting the most efficient way of query execution.
Full: Performs a full vacuum via reindexing all table files.
Note
While the vacuum is being performed in this mode, all sessions working with tables that are being reindexed will be blocked.
Freeze: Performs an aggressive tuple freeze to expand freezing and release transaction IDs for further reuse.
The aggressive freeze is always performed when overwriting the table, so do not select Freeze if Full is already selected.
Set cron-string execution: Allows specifying the interval for vacuuming in the crontab format.
If you turn on this toggle, in Execution, enter the string.
Execution: The type of the vacuuming schedule.
Possible values:
Execute now: Vacuuming will be performed immediately after you perform this instruction.
Once: Vacuuming will be performed at the specified date and time.
Repeated: Vacuuming will be performed at the specified interval.
For this value, specify the following parameters:
Interval: The unit of measurement of the interval.
Possible values:
Minutes
Hours
Days
Repeat every: The interval for vacuuming by minutes or hours.
This parameter is available only if you select Minutes or Hours from Interval.
Execution days: The days when vacuuming will be performed.
Cron total line: The string in the crontab format that specifies the interval for vacuuming.
This parameter is available only if you turn off Set cron-string execution.
Name: The unique name of the vacuuming task.
This parameter is available only if you turn on Set cron-string execution or select Once / Repeated from Execution.
Time: The date and/or time when vacuuming will be performed.
This parameter is available only if you select Once from Execution or Days from Interval.
Start and Repeat untill: The start and end date and time for vacuuming.
These parameters are available only if you turn on Set cron-string execution or select Repeated from Execution.
Click Apply.
Confirm the operation.
Note
Depending on the number and size of tables, this operation may require significant resources so it is recommended to track it.