Re: Strange runtime partition pruning behaviour with 11.4

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Strange runtime partition pruning behaviour with 11.4
Дата
Msg-id 9c55d578-bb70-d439-6450-abc291957ec3@gmx.net
обсуждение исходный текст
Ответ на Re: Strange runtime partition pruning behaviour with 11.4  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Strange runtime partition pruning behaviour with 11.4  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: Strange runtime partition pruning behaviour with 11.4  (MichaelDBA <MichaelDBA@sqlexec.com>)
Список pgsql-performance
> it's posible to rewrite the query to:
>
>
> test=# explain analyse select count(*) from foo_bar_baz as fbb where foo_id = (select foo_id from foo where foo_name
='eeny'); 
>
> I know, that's not a solution, but a workaround. :-(

Yes, I discovered that as well.

But I'm more confused (or concerned) by the fact that the (original) query works correctly *without* statistics.

Thomas






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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Strange runtime partition pruning behaviour with 11.4
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Strange runtime partition pruning behaviour with 11.4