Method startSQLiteMaintenance

database/sql/sql.go:152–167

startSQLiteMaintenance runs periodic WAL checkpoint and VACUUM on both the main database and the objects database (if present). This reclaims disk space from deleted rows/blobs and keeps the WAL file from growing unbounded.

()

// main database and the objects database (if present). This reclaims disk space
// from deleted rows/blobs and keeps the WAL file from growing unbounded.
func (s *sqlDatabase) startSQLiteMaintenance() {
	ticker := time.NewTicker(24 * time.Hour)
	defer ticker.Stop()

	for {
		select {
		case <-s.ctx.Done():
			return
		case <-ticker.C:
			s.runSQLiteMaintenance(s.conn, "main")
			if s.objectsConn != nil {
				s.runSQLiteMaintenance(s.objectsConn, "objects")
			}
		}
	}
}

func (s *sqlDatabase) runSQLiteMaintenance(conn *gorm.DB, dbName string) {
	if err := conn.Exec("PRAGMA wal_checkpoint(TRUNCATE)").Error; err != nil {