Search Postgresql Archives

Re: Immutable function WAY slower than Stable function?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux