Re: WHERE condition not being pushed down to union parts

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WHERE condition not being pushed down to union parts
Дата
Msg-id 2297.1240325416@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WHERE condition not being pushed down to union parts  ("John L. Clark" <jlc6@po.cwru.edu>)
Список 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 по дате отправления:

Предыдущее
От: "John L. Clark"
Дата:
Сообщение: Re: WHERE condition not being pushed down to union parts
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: performance for high-volume log insertion