Re: Can dml realize the partition table's rule and make good execution plan?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can dml realize the partition table's rule and make good execution plan?
Дата
Msg-id 12905.1352730024@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Can dml realize the partition table's rule and make good execution plan?  (Craig Ringer <craig@2ndQuadrant.com>)
Список pgsql-general
Craig Ringer <craig@2ndQuadrant.com> writes:
> It'd be really interesting to enhance the query planner to be smarter
> about this particular case,

At least for this particular example, it's not at all clear to me that
it'd be worth the cost.  Getting rid of accesses to tables altogether is
worthwhile, but avoiding one very-low-cost arm of a BitmapOr is less so.

            regards, tom lane


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

Предыдущее
От: Chris Angelico
Дата:
Сообщение: Re: integer instead of 'double precision'?
Следующее
От: Shaun Thomas
Дата:
Сообщение: PSA: XFS and Linux Cache Poisoning