Re: Most effective settings for deleting lots of data? - Mailing list pgsql-general

From Rob Sargent
Subject Re: Most effective settings for deleting lots of data?
Date
Msg-id 55DE2A4A.1070201@gmail.com
Whole thread Raw
In response to Re: Most effective settings for deleting lots of data?  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Most effective settings for deleting lots of data?
Next
From: Merlin Moncure
Date:
Subject: Re: Grouping sets, cube and rollup