Re: LONG delete with LOTS of FK's

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