Re: Huge overestimation in rows expected results in bad plan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Huge overestimation in rows expected results in bad plan
Дата
Msg-id 20388.1289345380@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Huge overestimation in rows expected results in bad plan  (bricklen <bricklen@gmail.com>)
Ответы Re: Huge overestimation in rows expected results in bad plan  (bricklen <bricklen@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
bricklen <bricklen@gmail.com> writes:
> I have a query that is getting a pretty bad plan due to a massively
> incorrect count of expected rows.

The query doesn't seem to match the plan.  Where is that OR (c.id =
38441828354::bigint) condition coming from?

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: anti-join chosen even when slower than old plan
Следующее
От: bricklen
Дата:
Сообщение: Re: Huge overestimation in rows expected results in bad plan