Search Shortcut cmd + k | ctrl + k
VACUUM Statement

The VACUUM statement alone does nothing and is at present provided for PostgreSQL-compatibility. The VACUUM ANALYZE statement recomputes table statistics if they have become stale due to table updates or deletions.

Examples

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

Reclaiming Space

To reclaim space after deleting rows, use the CHECKPOINT statement.

Syntax

About this page

Last modified: 2024-02-24