VACUUM
Perform maintenance tasks, including updating inverted indexes after data changes.
Syntax
Parameters
| Parameter | Description |
|---|---|
| table_name | The table to vacuum |
UPDATE_INDEXES | Rebuild and optimize inverted indexes on the table |
Examples
Basic vacuum
VACUUM articles;
Update inverted indexes
After inserting or modifying data in a table with inverted indexes:
VACUUM (UPDATE_INDEXES) articles;