Re: planer picks a bad plan (seq-scan instead of index)

Поиск
Список
Период
Сортировка
От Thomas H.
Тема Re: planer picks a bad plan (seq-scan instead of index)
Дата
Msg-id 09b501c703d4$329eb380$0201a8c0@iwing
обсуждение исходный текст
Ответ на planer picks a bad plan (seq-scan instead of index) when adding an additional join  ("Thomas H." <me@alternize.com>)
Список pgsql-general
> Have you run analyze on all the three tables since creating the
> database?

yes. even a forced ANALYZE FULL after the table loads: the tables were
TRUNCATE'd, refilled and ANALYZE FULL'ed some minutes before the tests.
there where no UPDATEs after the INSERTs...

- thomas



В списке pgsql-general по дате отправления:

Предыдущее
От: "Shoaib Mir"
Дата:
Сообщение: Re: 8.1.2 postmaster died
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: planer picks a bad plan (seq-scan instead of index)