Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Constraint exclusion in partitions - Mailing list pgsql-general

From David G. Johnston
Subject Re: [NOVICE] Constraint exclusion in partitions
Date
Msg-id CAKFQuwZz2bC+DdXfgGOYcC+ZPg-AL2eqgfxr36t0xssQ5mSjgA@mail.gmail.com
Whole thread Raw
In response to Re: FW: Constraint exclusion in partitions  (Daniel Begin <jfd553@hotmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3
Next
From: Adrian Klaver
Date:
Subject: Re: Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3