Re: Do Views offer any performance advantage?

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: Do Views offer any performance advantage?
Дата
Msg-id 3E9D1820.6000100@web.de
обсуждение исходный текст
Ответ на Re: Do Views offer any performance advantage?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:

>This is not the view's fault though --- the same would have happened
>if you'd written explicitly
>
>    FROM A JOIN B JOIN (D JOIN E)
>
That's right, I just wanted to warn about accessive use of joins with
views. I noticed this in an application, where quite big views where
joined for convenience, and the result wasn't satisfying.

>
>7.4 will be less rigid about this (with or without a view ...)
>
Good!
Regards,
Andreas


В списке pgsql-performance по дате отправления:

Предыдущее
От: "dex"
Дата:
Сообщение: Is there a performance between Inherits and Views?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: for help!