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
|
Список | 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 по дате отправления: