Re: [PERFORM] WHERE condition not being pushed down to union parts

Thanks for your help, Tom. I am certainly amused and pleased that my exact use case is handled in the very next PostgreSQL release. Take care, John L. Clark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] WHERE condition not being pushed down to union parts

On Tue, Apr 21, 2009 at 12:05 PM, John L. Clark wrote: > On Tue, Apr 21, 2009 at 10:50 AM, Tom Lane wrote: >> In that case you're going to need to provide a reproducible test case, >> 'cause it worksforme. > > Ok. I scaled back my example by just selecting 1000 &

Re: [PERFORM] WHERE condition not being pushed down to union parts

config --version PostgreSQL 8.3.7 Other ideas? Take care, John L. Clark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] WHERE condition not being pushed down to union parts

N ALL SELECT relations.subject, relations.subject_term, relations.predicate, relations.predicate_term, relations.object, relations.object_term, relations.context, relations.context_term, NULL::bigint AS data_type, NULL::character varying(3) AS language FROM relations; Does anyone have any ide