Re: Performance of views - Mailing list pgsql-general

From Webb Sprague
Subject Re: Performance of views
Date
Msg-id b11ea23c0811021607o2cdbad03j87fd226839eb77a1@mail.gmail.com
Whole thread Raw
In response to Re: Performance of views  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: defining an existing Table Schema for Foreign Key Constraint - Question
Next
From: Sam Mason
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?