Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Example Purge Sequence

Example Purge Sequence

The example below shows a series of rolling partitions, with a new partition added as the specified partition is purged. The tables below show the total number of records plus the number of permanent records in each partition, based on two retention strategies:

Strategy A

Uses a historic partition to retain permanent records (that is, events flagged as ‘Do Not Delete’). Compared to strategy B, this approach typically makes it easier to manage your database because it results in fewer table partitions.

Strategy B

Does not use a historic partition. Instead, permanent records (see above) are retained in their original partition. The disadvantage of this strategy is that over time a large number of partitions can accumulate in the database.

More information:

1. Create Partitions

2. Run First Purge

3. Run Second Purge

Historic Partitions