Postgres Pro
Downloads
Home   >   mailing lists

Time penalty on VIEWS on VIEWS - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Time penalty on VIEWS on VIEWS
Date
Msg-id 20001105124859.C27532@gruby
Whole thread Raw
List pgsql-general
Tree view 
Hi,

My situation: VIEW A is grouping information from 2 tables (B,C). I have to
make another VIEW with additional WHERE statement compared in VIEW A. I can
make this as a VIEW groupping tables B and C, or makeing VIEW of VIEW A.
I know that second sollution is more flexible but there should be some kind of
time penalty. I'm wondering how much it is.

regards,

depesz


--
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Question about ordering views
Next
From: Stephan Szabo
Date:
Subject: Re: Referential integrity question