Re: Optimizer generates bad plans.

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Optimizer generates bad plans.
Дата
Msg-id Pine.LNX.4.33.0209191849470.15929-100000@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Optimizer generates bad plans.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Optimizer generates bad plans.  (Kris Jurka <books@ejurka.com>)
Список pgsql-hackers

On Thu, 19 Sep 2002, Tom Lane wrote:

> Kris Jurka <jurka@ejurka.com> writes:
> > While adding schema support to the JDBC Driver, I came across a query
> > which occasionally generates some spectacularly bad plans.
>
> Hm, does an ANALYZE help?
>

Yes, it does, but I don't understand why.  The query is entirely against
pg_catalog tables which have had all of three tables added to them.  How
can the new ANALYZE stats be significantly different than what came from
the ANALYZED template1.

Kris Jurka




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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Optimizer generates bad plans.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Optimizer generates bad plans.