From: | Amit V Shah <ashah(at)tagaudit(dot)com> |
---|---|
To: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Do Views execute underlying query everytime ?? |
Date: | 2005-06-21 14:01:21 |
Message-ID: | 0C072E7CC947D511AC9600A0CC7341200256CF51@vpn.tagaudit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi all,
I have like a repository table with is very very huge with atleast a few
hundreds of millions, may be over that. The information is stored in form of
rows in these tables. I need to make that information wide based on some
grouping and display them as columns on the screen.
I am thinking of having a solution where I create views for each screen,
which are just read only.
However, I donot know if the query that creates the view is executed
everytime I select something from the view. Because if that is the case,
then I think my queries will again be slow. But if that is the way views
work, then what would be the point in creating them ..
Any suggestions, helps --
(Please pardon if this question should not be on performance forum)
Thanks,
Amit
From | Date | Subject | |
---|---|---|---|
Next Message | Yves Vindevogel | 2005-06-21 14:33:55 | Limit clause not using index |
Previous Message | Alex Stapleton | 2005-06-21 10:04:45 | Re: autovacuum suggestions for 500,000,000+ row tables? |