Re: LONG delete with LOTS of FK's - Mailing list pgsql-general

From Gavin Flower
Subject Re: LONG delete with LOTS of FK's
Date
Msg-id 5196A5F6.3000500@archidevsys.co.nz
Whole thread Raw
In response to Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Responses Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
List 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

pgsql-general by date:

Previous
From: Ramsey Gurley
Date:
Subject: Re: Tuning read ahead continued...
Next
From: Larry Rosenman
Date:
Subject: Re: LONG delete with LOTS of FK's