Stored procedure declared as VOLATILE => no good optimization is done

Поиск
Список
Период
Сортировка
От Damon Snyder
Тема Stored procedure declared as VOLATILE => no good optimization is done
Дата
Msg-id AANLkTik6ynVXSZL9zbAcB12-+S1RfLoNQUGNANTNJjsH@mail.gmail.com
обсуждение исходный текст
Ответы Re: Stored procedure declared as VOLATILE => no good optimization is done  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Hello,
I have heard it said that if a stored procedure is declared as VOLATILE, then no good optimizations can be done on queries within the stored procedure or queries that use the stored procedure (say as the column in a view). I have seen this in practice, recommended on the irc channel, and in the archives (http://archives.postgresql.org/pgsql-performance/2008-01/msg00283.php). Can someone help me understand or point me to some documentation explaining why this is so? 

Any insights would be appreciated. I'm new to pgsql and would like to know a little more about what is going on under the hood.

Thanks,
Damon

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Slow count(*) again...
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Slow count(*) again...