Re: View vs Stored Proc Performance

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: View vs Stored Proc Performance
Дата
Msg-id m2k504tm7y.fsf@hi-media.com
обсуждение исходный текст
Ответ на Re: View vs Stored Proc Performance  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: View vs Stored Proc Performance  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Merlin Moncure <mmoncure@gmail.com> writes:
> like joining the result to another table...the planner can see
> 'through' the view, etc.  in a function, the result is fetched first
> and materialized without looking at the rest of the query.

I though the planner would "see through" SQL language functions and
inline them when possible, so they often can make for parametrized
views...

Regards,
--
dim

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: slow query : very simple delete, 100% cpu, nearly no disk activity
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: View vs Stored Proc Performance