Postgres Pro
Downloads
Home   >   mailing lists

Re: Immutable function WAY slower than Stable function? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Immutable function WAY slower than Stable function?
Date
Msg-id 03120a03-75d0-ad6c-691c-35ca7e7fccfa@aklaver.com
Whole thread Raw
In response to Immutable function WAY slower than Stable function?  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses Re: Immutable function WAY slower than Stable function?
List pgsql-general
Tree view 
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 by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Immutable function WAY slower than Stable function?
Next
From: Ken Tanzer
Date:
Subject: Re: Immutable function WAY slower than Stable function?