Re: Optimizer's issue

Поиск
Список
Период
Сортировка
От Vlad Arkhipov
Тема Re: Optimizer's issue
Дата
Msg-id 48105739.30900@dc.baikal.ru
обсуждение исходный текст
Ответ на Re: Optimizer's issue  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: Optimizer's issue  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
Albe Laurenz пишет:
> Vlad Arkhipov wrote:
>
>> I found strange issue in very simple query.
>>
>
> You forgot to mention what your problem is.
>
> Yours,
> Laurenz Albe
>
It was written below in my first post:
"These queries are part of big query and optimizer put them on the leaf
of query tree, so rows miscount causes a real problem. "
actual rows count for the first query is 294, estimate - 11; for the
second -- 283 and 0. Postgres tries to use nested loops when it should
use merge/hash join and vice versa.


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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: off-topic: SPAM
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Optimizer's issue