Re: [NOVICE] Constraint exclusion in partitions

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [NOVICE] Constraint exclusion in partitions
Дата
Msg-id CAKFQuwZz2bC+DdXfgGOYcC+ZPg-AL2eqgfxr36t0xssQ5mSjgA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FW: Constraint exclusion in partitions  (Daniel Begin <jfd553@hotmail.com>)
Список pgsql-general
On Saturday, May 23, 2015, Daniel Begin <jfd553@hotmail.com> wrote:

I am working with postgresql 9.3 and I understand from the documentation that constraint_exclusion is set to “partition” by default. Looking at my postgres.conf file, the concerned line is “#constraint_exclusion = partition”. 

Furthermore, the execution plan shows that constraint_exclusion was used at least for constant id and range of ids

What is your question/concern? 

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