Re: Views + UNION ALL = Slow ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Views + UNION ALL = Slow ?
Date
Msg-id 10920.1098329002@sss.pgh.pa.us
Whole thread Raw
In response to Views + UNION ALL = Slow ?  (o.blomqvist@secomintl.com (Otto Blomqvist))
List pgsql-general
o.blomqvist@secomintl.com (Otto Blomqvist) writes:
> I am obviously doing something wrong or using something the wrong way.

What PG version are you using?  7.3 and later can push the WHERE
condition down into the view, but older versions won't.

            regards, tom lane

pgsql-general by date:

Previous
From: "Hicham G. Elmongui"
Date:
Subject: Re: generic sql question
Next
From: Tino Wildenhain
Date:
Subject: Re: table size/record limit