On 11/12/2012 10:39 AM, 高健 wrote: > The selection used where condition for every partition table, which > is not what I want. my rule is just for id column value. Is `constraint_exclusion` turned on?
http://www.postgresql.org/docs/current/static/ddl-partitioning.html <http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html> http://www.postgresql.org/docs/current/static/runtime-config-query.html#GUC-CONSTRAINT-EXCLUSION <http://www.postgresql.org/docs/9.2/static/runtime-config-query.html#GUC-CONSTRAINT-EXCLUSION> -- Craig Ringer