Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a number of tables that were partitioned primarily to reduce problems when purging data (via sliding-window partitioning / truncate). I have found a number of caveats that come with partitioning and am wondering whether partitioning is worth it in our case.

Thus far from what we have encountered,

The pros are:

  • Low overhead (locks, speed) in sliding large amounts of data into separate table for truncation (our primary concern)
  • Increased performance.

The cons are:

  • Dealing with foreign keys to the table when sliding the partitions around.
  • Additional data required in indexes (and queries) to have aligned indexes
  • Other limitations associated with aligned indexes? (comments please)

What other types of benefits or limitations should we expect to see as we go forward?

share|improve this question

closed as too broad by Max Vernon, Mark Storey-Smith, StanleyJohns, dezso, bluefeet Sep 27 '13 at 11:35

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.