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

From: Craig Ringer <craig(at)2ndQuadrant(dot)com>
To: 高健 <luckyjackgao(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can dml realize the partition table's rule and make good execution plan?
Date: 2012-11-12 03:01:11
Message-ID: 50A06677.7060603@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-11-12 03:23:22 Re: Can dml realize the partition table's rule and make good execution plan?
Previous Message 高健 2012-11-12 02:39:18 Can dml realize the partition table's rule and make good execution plan?