Dropping Old Partitions

Dropping old partitions is only supported for a Postgres database.

  • Postgres Users:

    For a Postgres database, partitions can be dropped by running the drop_partition_by_name.sql file.

    Refer to the Partition_Drop_Readme.txt file under $AF_HOME/db/postgreSQL/purge for additional details on the setup and run procedure.

    Note: Dropping a partition in a PostgreSQL database is allowed only when all of the orders in that partition are either COMPLETE or CANCELLED. If there are any open orders in the partition, the drop partition process aborts.

    In case a partition has open orders, you can use the purge orders script $AF_HOME/db/postgreSQL/purge/OMS_purge_orders.sh to purge selective orders instead.