From: Fayza Sultan <fayza.sultan@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Enabling constraint_exclusion does not avoid scanning all child partitions
Date: Mon, 4 Dec 2006 03:37:37 +0500
Message-ID: <38443e510612031437h30337dejc928f059fb5fa79c@mail.gmail.com> (raw)
In-Reply-To: <24770.1165184727@sss.pgh.pa.us>
References: <38443e510612031421y3d8f8f05x8befb7adc166717d@mail.gmail.com>
<24770.1165184727@sss.pgh.pa.us>
Your point solved my problem.
Thank you
-Fayza
On 12/4/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Fayza Sultan" <fayza.sultan@gmail.com> writes:
> > CREATE TABLE parent (
> > monthdate date NOT NULL,
> > id int4 NOT NULL,
> > CONSTRAINT parent_idx PRIMARY KEY (monthdate,id )
> > );
>
> > CREATE TABLE child1
> > (
> > CONSTRAINT child1_idx PRIMARY KEY (monthdate,id),
> > CONSTRAINT child1_chk CHECK (monthdate >= '2006-01-01
> 00:00:00'::timestamp
> > without time zone AND monthdate < '2006-02-01 00:00:00'::timestamp
> without
> > time zone)
>
> monthdate is date, not timestamp. See the caveat in the documentation
> about avoiding cross-type comparisons when formulating constraints for
> constraint exclusion to use.
>
> regards, tom lane
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fayza.sultan@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Enabling constraint_exclusion does not avoid scanning all child partitions
In-Reply-To: <38443e510612031437h30337dejc928f059fb5fa79c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox