Starburst Galaxy

  •  Get started

  •  Working with data

  •  Data engineering

  •  Developer tools

  •  Cluster administration

  •  Security and compliance

  •  Troubleshooting

  • Galaxy status

  •  Reference

  • Live table maintenance #

    Starburst Galaxy performs table maintenance operations as part of live table management. These maintenance operations improve performance and reduce storage on live tables.

    Whether your data is ingested from JSON files or from a Kafka topic, Galaxy performs the following table maintenance operations automatically:

    Compaction
    Improves performance by optimizing your data file size.
    Snapshot expiration
    Reduce storage by deleting older data snapshots. This action runs several times per day and expires snapshots older than 30 days.
    Data retention
    Reduces storage by deleting data snapshots according to the retention threshold you specify.
    Vacuuming
    Reduces storage by deleting orphaned data files.