Skip to main content

VacuumTruncate

Short Description

Waiting to acquire an exclusive lock to truncate off any empty pages at the end of a table vacuumed

Additional Information

The VacuumTruncate wait is seen when empty pages are being truncated at the end of a vacuumed table. An exclusive lock is required for this operation.

How to reduce this wait

Adjust vacuum_cost_delay, vacuum_cost_page_hit, vacuum_cost_page_miss, vacuum_cost_page_dirty and vacuum_cost_limit parameters to control the vacuum load.

PostgreSQL docs - Routine Vacuuming

PostgreSQL docs - Wait Events of Type Activity

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.