Method migrateAutoVacuum

database/sql/sql.go:492–508

migrateAutoVacuum converts SQLite databases from auto_vacuum=NONE to auto_vacuum=INCREMENTAL. This is a one-time migration that allows the periodic maintenance goroutine to use PRAGMA incremental_vacuum to efficiently reclaim free pages without rebuilding the entire database.

()

// periodic maintenance goroutine to use PRAGMA incremental_vacuum to
// efficiently reclaim free pages without rebuilding the entire database.
func (s *sqlDatabase) migrateAutoVacuum() error {
	if s.cfg.DbBackend != config.SQLiteBackend {
		return nil
	}

	if err := s.enableIncrementalVacuum(s.conn, "main"); err != nil {
		return err
	}

	if s.objectsConn != nil {
		if err := s.enableIncrementalVacuum(s.objectsConn, "objects"); err != nil {
			return err
		}
	}

	return nil
}

func (s *sqlDatabase) enableIncrementalVacuum(conn *gorm.DB, dbName string) error {
	var autoVacuum int