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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Can dml realize the partition table's rule and make good execution plan?
Дата
Msg-id 50A06677.7060603@2ndQuadrant.com
обсуждение исходный текст
Ответ на Can dml realize the partition table's rule and make good execution plan?  (高健 <luckyjackgao@gmail.com>)
Список pgsql-general
On 11/12/2012 10:39 AM, 高健 wrote:

The selection used where condition for every  partition table, which is not what I want. my rule is just for id column value.
Is `constraint_exclusion` turned on?

http://www.postgresql.org/docs/current/static/ddl-partitioning.html
http://www.postgresql.org/docs/current/static/runtime-config-query.html#GUC-CONSTRAINT-EXCLUSION

--
Craig Ringer

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

Предыдущее
От: 高健
Дата:
Сообщение: Can dml realize the partition table's rule and make good execution plan?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Can dml realize the partition table's rule and make good execution plan?