Re: Performance of views

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Simon Windsor" <simon(dot)windsor(at)cornfield(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Performance of views
Date: 2008-11-03 00:07:55
Message-ID: b11ea23c0811021607o2cdbad03j87fd226839eb77a1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Am I right to avoid to VIEWS within application code?

How one uses views is more a matter of taste and best practices, than
a matter of rules like this. Frankly, this "rule" sounds rather ill
conceived.

My feeling is that views can be difficult to maintain when they are
nested, but otherwise use them whenever they simplify matters. I also
feel that they should only be defined for when they represent, well,
views of the data that make sense in a long term way; don't use them
if for a one-off application.

As for performance -- let me reiterate: create the most elegant
design, possibly with views, and only worry about performance AFTER
PROFILING.

-W

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-11-03 00:44:14 Re: Are there plans to add data compression feature to postgresql?
Previous Message Sam Mason 2008-11-02 23:58:05 Re: defining an existing Table Schema for Foreign Key Constraint - Question