Re: Partition elimination problem -> Solved

From: "Milen Kulev" <makulev(at)gmx(dot)net>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Partition elimination problem -> Solved
Date: 2006-09-18 06:09:55
Message-ID: 000501c6dae9$104859d0$0a00a8c0@trivadis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

.... 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:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, September 18, 2006 1:14 AM
To: Milen Kulev
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Partition elimination problem

"Milen Kulev" <makulev(at)gmx(dot)net> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mikael Carneholm 2006-09-18 07:38:10 Re: Optimize SQL
Previous Message Milen Kulev 2006-09-18 06:07:51 Re: Partition elimination problem