procedures

object AnalyzePartitions extends SqlProcedure with CronSchedule

Runs 'analyze' on partitions that have been modified
object CompactPartitions extends SqlProcedure

Re-sorts a partition table.
Re-sorts a partition table. Can be used for maintenance if time-latent data comes in and degrades performance of the BRIN index
object DropAgedOffPartitions extends SqlProcedure

Drops any partitions older than the configured maximum
object MergeWriteAheadPartitions extends SqlProcedure

Merge recent write-ahead partitions and move them into the main partition table
object PartitionMaintenance extends SqlProcedure with CronSchedule

High level procedure to manage data shuffling between write-ahead table and partitioned tables
object PartitionWriteAheadLog extends SqlProcedure

Partitions the write ahead table into the recent and/or main partition tables
object RollWriteAheadLog extends SqlProcedure with CronSchedule

Moves the current write ahead table to a sequential name, and creates a new write ahead table to accept writes going forward