Re: complicated queries in pl/pgsql

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: complicated queries in pl/pgsql
Дата
Msg-id 200301131044.50424.josh@agliodbs.com
обсуждение исходный текст
Ответ на complicated queries in pl/pgsql  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-performance
 Tomasz,

> What happens to view planning - is it performed
> during view creation, or rather each time view is quered?

Each time the view is executed.   The only savings in running a view over a
regular query is that the view will have taken care of some reference
expansion and JOIN explication during the CREATE process, but not planning.
Also, views can actually be slower if the view is complex enough that any
query-time parameters cannot be "pushed down" into the view.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: CaptainX0r
Дата:
Сообщение: Re: Sun vs. Mac
Следующее
От: CaptainX0r
Дата:
Сообщение: Re: Sun vs. Mac - best Postgres platform?