Re: Can dml realize the partition table's rule and make good execution plan?

Craig Ringer <craig@xxxxxxxxxxxxxxx> · Mon, 12 Nov 2012 11:01:11 +0800



    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/current/static/runtime-config-query.html#GUC-CONSTRAINT-EXCLUSION

    
    --

    Craig Ringer