pgsql: Create a third option named "partition" for constraint_exclusion,

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create a third option named "partition" for constraint_exclusion,
Date: 2009-01-07 22:40:49
Message-ID: 20090107224049.D1E0B754A1B@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Create a third option named "partition" for constraint_exclusion, and make it
the default. This setting enables constraint exclusion checks only for
appendrel members (ie, inheritance children and UNION ALL arms), which are
the cases in which constraint exclusion is most likely to be useful. Avoiding
the overhead for simple queries that are unlikely to benefit should bring
the cost down to the point where this is a reasonable default setting.
Per today's discussion.

Modified Files:
--------------
pgsql/doc/src/sgml:
config.sgml (r1.202 -> r1.203)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.202&r2=1.203)
ddl.sgml (r1.83 -> r1.84)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml?r1=1.83&r2=1.84)
textsearch.sgml (r1.46 -> r1.47)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.46&r2=1.47)
pgsql/src/backend/optimizer/util:
plancat.c (r1.153 -> r1.154)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/plancat.c?r1=1.153&r2=1.154)
pgsql/src/backend/utils/misc:
guc.c (r1.490 -> r1.491)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.490&r2=1.491)
postgresql.conf.sample (r1.249 -> r1.250)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample?r1=1.249&r2=1.250)
pgsql/src/include/optimizer:
cost.h (r1.95 -> r1.96)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/cost.h?r1=1.95&r2=1.96)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2009-01-07 22:54:46 pgsql: Add comment about why BETWEEN uses operator strings and not
Previous Message Bruce Momjian 2009-01-07 21:48:17 Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the