Re: why doesn't optimizer can pull up where a > ( ... )

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: why doesn't optimizer can pull up where a > ( ... )
Дата
Msg-id 9C80C272-B3F0-4583-A9F7-62CF06FB72DC@yesql.se
обсуждение исходный текст
Ответ на why doesn't optimizer can pull up where a > ( ... )  (Andy Fan <zhihui.fan1213@gmail.com>)
Ответы Re: why doesn't optimizer can pull up where a > ( ... )  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
> On 20 Nov 2019, at 13:15, Andy Fan <zhihui.fan1213@gmail.com> wrote:

> 2.  why pg can't do it,  while greenplum can? 

It's worth noting that Greenplum, the example you're referring to, is using a
completely different query planner, and different planners have different
characteristics and capabilities.

cheers ./daniel

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

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: why doesn't optimizer can pull up where a > ( ... )
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: logical decoding : exceeded maxAllocatedDescs for .spill files