Re: WHERE condition not being pushed down to union parts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John L(dot) Clark" <jlc6(at)po(dot)cwru(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: WHERE condition not being pushed down to union parts
Date: 2009-04-21 14:50:16
Message-ID: 2297.1240325416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"John L. Clark" <jlc6(at)po(dot)cwru(dot)edu> writes:
> On Tue, Apr 21, 2009 at 10:35 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> You never mentioned what PG version you are using, but I'm betting
>> it's 8.1.x. This should work the way you are expecting in 8.2 and up.

> Naturally, I would forget (at least) one critical piece of information:

> $ pg_config --version
> PostgreSQL 8.3.7

In that case you're going to need to provide a reproducible test case,
'cause it worksforme.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message david 2009-04-21 15:37:54 Re: performance for high-volume log insertion
Previous Message John L. Clark 2009-04-21 14:41:09 Re: WHERE condition not being pushed down to union parts