Re: LONG delete with LOTS of FK's

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: LONG delete with LOTS of FK's
Дата
Msg-id d6afdf62-e63b-4539-ae98-728cc8c23432@email.android.com
обсуждение исходный текст
Ответ на Re: LONG delete with LOTS of FK's  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: LONG delete with LOTS of FK's
Следующее
От: Raghavendra
Дата:
Сообщение: Re: Regarding Postgres Plus Associate Certification