Re: LONG delete with LOTS of FK's

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: David Kerr <dmk(at)mr-paradox(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: LONG delete with LOTS of FK's
Date: 2013-05-17 21:49:42
Message-ID: 5196A5F6.3000500@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18/05/13 03:06, Larry Rosenman wrote:
> On 2013-05-16 18:35, David Kerr wrote:
>
>> - I'll take a look tomorrow, but we WERE seeing Seq Scan's against
>> - multi-million
>> - row tables, so I suspect Tom is right on with the replanning that's in
>> - 9.2 fixing
>> - it, and I'm in the process of validating that.
>>
>> That seems likely, although you could try enable_seqscan=false as well.
>>
>> Dave
> The 9.2 upgrade DOES fix my issue.
>
> Thanks again, Tom and everyone.
>
>
Did you also */enable_seqscan=false as well/*?

Cheers,
Gavin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2013-05-17 22:12:02 Re: LONG delete with LOTS of FK's
Previous Message Ramsey Gurley 2013-05-17 21:19:41 Re: Tuning read ahead continued...