Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group