Postgres Pro
Downloads
Home   >   mailing lists

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

From Larry Rosenman
Subject Re: LONG delete with LOTS of FK's
Date
Msg-id d6afdf62-e63b-4539-ae98-728cc8c23432@email.android.com
Whole thread Raw
In response to Re: LONG delete with LOTS of FK's  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view
Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
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

No.  Same set up as 9.1
--
Sent from Kaiten Mail. Please excuse my brevity.

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: LONG delete with LOTS of FK's
Next
From: Raghavendra
Date:
Subject: Re: Regarding Postgres Plus Associate Certification