lshift/diffa — Issue #17: Pair deletion can fail in Oracle
Author: johnwright
Created: 2011-12-22 12:10:58+00:00
State: open

We've seen the `removeDiffsByPairAndDomain` query fail in Oracle due to insufficient undo space.

Possible fixes:

* Index the `domain` and `pair` columns, thus preventing a table scan
* Partition the `diffs` table
* Delete in batches