Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group