Re: WHERE condition not being pushed down to union parts - Mailing list pgsql-performance

From Tom Lane
Subject Re: WHERE condition not being pushed down to union parts
Date
Msg-id 2297.1240325416@sss.pgh.pa.us
Whole thread Raw
In response to Re: WHERE condition not being pushed down to union parts  ("John L. Clark" <jlc6@po.cwru.edu>)
List pgsql-performance
"John L. Clark" <jlc6@po.cwru.edu> writes:
> On Tue, Apr 21, 2009 at 10:35 AM, Tom Lane <tgl@sss.pgh.pa.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

pgsql-performance by date:

Previous
From: "John L. Clark"
Date:
Subject: Re: WHERE condition not being pushed down to union parts
Next
From: david@lang.hm
Date:
Subject: Re: performance for high-volume log insertion