Re: Views + UNION ALL = Slow ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: o(dot)blomqvist(at)secomintl(dot)com (Otto Blomqvist)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Views + UNION ALL = Slow ?
Date: 2004-10-21 03:23:22
Message-ID: 10920.1098329002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

o(dot)blomqvist(at)secomintl(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-21 04:00:50 Re: Invalid page header
Previous Message Hicham G. Elmongui 2004-10-21 03:04:03 Re: generic sql question