Re: Most effective settings for deleting lots of data?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Most effective settings for deleting lots of data?
Date: 2015-08-26 21:06:18
Message-ID: 55DE2A4A.1070201@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2015-08-26 22:09:26 Re: Grouping sets, cube and rollup
Previous Message Alan Hodgson 2015-08-26 20:34:04 Re: Most effective settings for deleting lots of data?