Skip to main content

MIN_PAGES_FOR_AUTO_VACUUM

Constant MIN_PAGES_FOR_AUTO_VACUUM 

Source
pub const MIN_PAGES_FOR_AUTO_VACUUM: u32 = 16;
Expand description

Auto-VACUUM (SQLR-10) does not fire on databases below this many pages. The 4 KiB page size makes 16 pages = 64 KiB — small enough that the cost of a full-file rewrite is negligible if the user genuinely wants it (manual VACUUM; still works), but large enough that single-table churn doesn’t blow past the threshold and trigger a noisy compact every few statements.