Re: Most effective settings for deleting lots of data?

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 08/26/2015 02:34 PM, Alan Hodgson wrote:

On Wednesday, August 26, 2015 08:25:02 PM Cory Tucker wrote:

What settings would you recommend?  Also, it just occurred to me that I
should try to disable/drop all indexes (especially since they will be
recreated) later so that those are not updated in the process.

Don't drop the indexes your foreign keys use to find cascading deletes.

Or do drop indexes and walk up your dependency graph manually.