How efficient are Views

From: John Taylor <postgres(at)jtresponse(dot)co(dot)uk>
To: "PgSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: How efficient are Views
Date: 2002-06-12 15:02:07
Message-ID: 02061216020706.03223@splash.hq.jtresponse.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm thinking about using a view for my application.

However, I'm wondering about how efficient it will be once I have a large amount of data
loaded.

Are views generated for every access ?
Are they generated when the underlying data changes ?

Whould it maybe be faster to have a seperate table alongside the base data, and
generate it via a trigger or stored procedure ?

Thanks
JohnT

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John Taylor 2002-06-12 15:07:26 Optimising inside transactions
Previous Message ben.carlyle 2002-06-11 23:35:08 Postgresql Historical data store