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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3