Re: LONG delete with LOTS of FK's

Поиск
Список
Период
Сортировка
От Gavin Flower
Тема Re: LONG delete with LOTS of FK's
Дата
Msg-id 5196A5F6.3000500@archidevsys.co.nz
обсуждение исходный текст
Ответ на Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Список 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 по дате отправления:

Предыдущее
От: Ramsey Gurley
Дата:
Сообщение: Re: Tuning read ahead continued...
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: LONG delete with LOTS of FK's