Re: WHERE condition not being pushed down to union parts

From: Tom Lane
Subject: Re: WHERE condition not being pushed down to union parts
Date: ,
Msg-id: 2297.1240325416@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: WHERE condition not being pushed down to union parts  ("John L. Clark")
List: pgsql-performance


"John L. Clark" <> writes:
> On Tue, Apr 21, 2009 at 10:35 AM, Tom Lane <> 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:

From: Tom Lane
Date:
Subject: Re: WHERE condition not being pushed down to union parts
From: Greg Smith
Date:
Subject: Re: performance for high-volume log insertion