pgsql: Create a third option named "partition" for constraint_exclusion, - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Create a third option named "partition" for constraint_exclusion,
Date
Msg-id 20090107224049.D1E0B754A1B@cvs.postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Have current_query() use ActivePortal->sourceText rather than
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add comment about why BETWEEN uses operator strings and not