Title: Nachricht
Hi listers,I wanted to try PG partitioning (aka constraint
exclusion) with two levels .I am using PG 8.1.3 on
RHEL4U2,My setup:CREATE TABLE part (
id1 int not null, id2
int not null, id3 int not
null, filler varchar(200)
);--- level 1 partitions
"Milen Kulev" <[EMAIL PROTECTED]> writes:
> My Problem is that I don't see partiotion elimination feature (Parameer =
> constraint_exclusion is ON):
Your example works as expected for me. You *sure* you have
constraint_exclusion turned on?
regards, tom lane
Title: Nachricht
Hi Tom,You are right, of course :pgpool=#
set constraint_exclusion = on ;SETpgpool=# explain analyze
select * from part where id1=3 and id2=5
;
QUERY
PLAN
And sorry for the hassle.
I was running the db cluster with Tthw wrong(old) postgresql.conf ;(
Best Regrads.
Milen
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 1:14 AM
To: Milen Kulev
Cc: pgsql-performance@postgresql.org
Subj
