Re: Performance of views

Поиск
Список
Период
Сортировка
От Webb Sprague
Тема Re: Performance of views
Дата
Msg-id b11ea23c0811021607o2cdbad03j87fd226839eb77a1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of views  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: defining an existing Table Schema for Foreign Key Constraint - Question
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?