Re: MIN/MAX optimization for partitioned table

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: MIN/MAX optimization for partitioned table
Дата
Msg-id 407d949e0907171445m5c192ffeqe43f7aef5496acd0@mail.gmail.com
обсуждение исходный текст
Ответ на MIN/MAX optimization for partitioned table  (Alan Li <ali@truviso.com>)
Ответы Re: MIN/MAX optimization for partitioned table  (Alan Li <ali@truviso.com>)
Список pgsql-hackers
Neat! I haven't read the patch yet but I have some questions.

Does this handle the case where some partitions have an index and
others don't? Ie. Does it just apply the regular optimization to each
partition and then slap on the aggregate node? I think that's actually
a realistic case because people often don't have indexes on empty
partitions like the parent partition or a new partition which has just
been added and doesn't have indexes yet.

Is there any overlap with the ordered-append patch which is also in
the pipeline? afaict it covers similar cases but doesn't actually
overlap since the min/max optimization avoids having to do a sort
anywhere.

-- 
greg
http://mit.edu/~gsstark/resume.pdf


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

Предыдущее
От: Martin Pihlak
Дата:
Сообщение: Re: Non-blocking communication between a frontend and a backend (pqcomm)
Следующее
От: David Fetter
Дата:
Сообщение: Re: Enhancement - code completion when typing set search_path