Re: Slow execution time when querying view with WHERE clause - Mailing list pgsql-performance

Mike Mascari wrote:
> I have the following view:
>
> create or replace view market.p_areas as
> select a.*
> from _areas a
> where a.area in (
>  select b.area
>  from _bins b, _inventories i, _offers o, _pricemembers p
>  where b.bin = i.bin and
>  i.inventory = o.inventory and
>  o.pricegroup = p.pricegroup and
>  p.buyer in (
>   select s.store
>   from _stores s, _webusers w
>   where w.webuser = getWebuser() and
>   w.company = s.company
>    union
>   select s.store
>   from _stores s, _companies c
>   where s.company = c.company and
>   c.companyid = 'DEFAULT'
>  )
> );

...

I failed to report the version:

select version();

PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.4.0 20040204 (prerelease)

Sorry.

Mike Mascari