IMMUTABLE STABLE functions, daily updates - Mailing list pgsql-performance

From Sorin Dudui
Subject IMMUTABLE STABLE functions, daily updates
Date
Msg-id 13DE38ECCB7CE74890E7150A7CCB610D3642D8DC@exc1.wigeo.lan
Whole thread Raw
Responses Re: IMMUTABLE STABLE functions, daily updates  (Thom Brown <thom@linux.com>)
List pgsql-performance

Hi,

 

I have some functions that select data from tables which are daily or monthly updated.  My functions are marked as STABLE. I am wondering if they perform better if I mark they as IMMUTABLE?

 

Thank you,

Sorin

 

pgsql-performance by date:

Previous
From: Jay Levitt
Date:
Subject: Re: Subquery in a JOIN not getting restricted?
Next
From: Thom Brown
Date:
Subject: Re: IMMUTABLE STABLE functions, daily updates