TRUNCATE removes all rows from a partition without scanning it, making it significantly faster than DELETE for large tables. It is equivalent to running DELETE on each table with no conditions specified. After truncation, disk space is reclaimed immediately — no subsequent VACUUM is needed.
Syntax
TRUNCATE [ PARTITION ] name [ CASCADE | RESTRICT ]Example
The following statement truncates a partition named tab_range:
TRUNCATE tab_range;