8.6.4.4 Maintaining Partitions

Partition maintenance procedures remove old data from the database so that the database does not continue to grow until space is insufficient. Daily, weekly, or monthly maintenance is necessary for those tables that have daily, weekly, and monthly partitions, respectively. Partition maintenance performs the following actions:

• Copies information related to open orders from the oldest partitions to temp tables (EXECUTION, ORDR, ORDR_EVENT, ORDR_STATE_CHANGE TRADE and TRADE_EXECUTION_EVENT)
• Drops the oldest partitions for all partition types.
• Inserts the saved data into what is now the oldest partition (applicable to tables with open orders).
• Creates the new partitions.
• Recompiles the views that scenarios use.