IMMUTABLE STABLE functions, daily updates

From: Sorin Dudui <sd(at)wigeogis(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: IMMUTABLE STABLE functions, daily updates
Date: 2011-11-10 13:05:56
Message-ID: 13DE38ECCB7CE74890E7150A7CCB610D3642D8DC@exc1.wigeo.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thom Brown 2011-11-10 13:25:01 Re: IMMUTABLE STABLE functions, daily updates
Previous Message Jay Levitt 2011-11-09 20:39:14 Re: Subquery in a JOIN not getting restricted?