.... 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 Subject: Re: [PERFORM] Partition elimination problem "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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match