Do Views execute underlying query everytime ??

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

Responses

Browse pgsql-performance by date

  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?