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:
Соглашаюсь с условиями обработки персональных данных