Vacuum

The VACUUM statement is primarily in place for PostgreSQL compatibility.

Examples

-- No-op.
VACUUM;
-- Rebuild database statistics.
VACUUM ANALYZE;
-- Rebuild statistics for the table & column.
VACUUM ANALYZE memory.main.my_table(my_column);

Syntax

The VACUUM statement alone does nothing. VACUUM ANALYZE will recompute table statistics if they have become stale due to table updates or deletions.