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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

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 ?



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-2017 The PostgreSQL Global Development Group