1154769 - Implement IndexedDB periodic vacuum strategy

Status: RESOLVED DUPLICATE of bug 858680

(Core :: Storage: IndexedDB, defect)

Description

[Ben Kelly [:bkelly, not reviewing]]

On desktop IDB uses PRAGMA auto_vacuum=incremental, but never calls PRAGMA incremental_vacuum.  Without this second call the incremental vacuum is never actually performed.

  http://sqlite.org/pragma.html#pragma_auto_vacuum
  http://sqlite.org/pragma.html#pragma_incremental_vacuum

So desktop is paying the cost of accounting for page changes in the db, but never actually removing unused pages.

Comment 1

[Ben Turner (not reading bugmail, use the needinfo flag!)]

Yeah, this was intentional. We're going to do it this quarter, just didn't want to have to do two full VACUUMs (previous schema change requires a VACUUM, turning on auto_vacuum requires a VACUUM).