On 10 November 2011 13:05, Sorin Dudui <sd@xxxxxxxxxxxx> wrote: > 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? No. IMMUTABLE is only appropriate when there is no access to table data from within the function. An example of IMMUTABLE functions would be mathematical operations, where only the inputs and/or function constants are used to produce a result. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
