top | item 42340549

(no title)

darthShadow | 1 year ago

FWIW, auto_vacuum set to INCREMENTAL doesn't do any vacuuming automatically; it just stores the information needed to vacuum the DB.

From https://www.sqlite.org/pragma.html#pragma_auto_vacuum:

> When the value of auto-vacuum is 2 or "incremental" then the additional information needed to do auto-vacuuming is stored in the database file but auto-vacuuming does not occur automatically at each commit as it does with auto_vacuum=full. In incremental mode, the separate incremental_vacuum pragma must be invoked to cause the auto-vacuum to occur.

discuss

order

No comments yet.