Re: Immutable function WAY slower than Stable function?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Immutable function WAY slower than Stable function?
Дата
Msg-id 03120a03-75d0-ad6c-691c-35ca7e7fccfa@aklaver.com
обсуждение исходный текст
Ответ на Immutable function WAY slower than Stable function?  (Ken Tanzer <ken.tanzer@gmail.com>)
Ответы Re: Immutable function WAY slower than Stable function?  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
On 08/06/2018 03:49 PM, Ken Tanzer wrote:
> Hi.  I was recently troubleshooting a function, and realized it had 
> incorrectly been declared as Immutable, when it should have been 
> declared Stable.  When I changed it to Stable, the query I was running 
> ran dramatically faster. Digging into this a little more, this is what I 
> found:
> 

> 
> Happy to provide any additional relevant info, or for someone to point 
> out what obvious thing I'm overlooking.  Thanks in advance!

What is the definition for target_date()?

> 
> Ken
> 
> 
> 
> -- 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: Immutable function WAY slower than Stable function?
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Immutable function WAY slower than Stable function?