Re: Enabling constraint_exclusion does not avoid scanning all child partitions
This is a discussion on Re: Enabling constraint_exclusion does not avoid scanning all child partitions within the Pgsql Performance forums, part of the PostgreSQL category; --> 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> ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 09:49 AM
| ||||
| ||||
 Re: Enabling constraint_exclusion does not avoid scanning all child partitions 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 >      |
 |
« Regex performance issue
|
Enabling constraint_exclusion does not avoid scanning all child partitions »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:56 AM.
