Re: How efficient are Views - Mailing list pgsql-novice

From Henshall, Stuart - WCP
Subject Re: How efficient are Views
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F748E5@MAIL_EXCHANGE
Whole thread Raw
In response to How efficient are Views  (John Taylor <postgres@jtresponse.co.uk>)
List pgsql-novice

A view just re-executes the query.
Therefore a view is as efficient as the query it's based upon :)
hth,
- Stuart

> -----Original Message-----
> From: John Taylor [mailto:postgres@jtresponse.co.uk]
>
> 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

pgsql-novice by date:

Previous
From: John Taylor
Date:
Subject: Optimising inside transactions
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: Optimising inside transactions