IMMUTABLE STABLE functions, daily updates

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

To: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
Subject: IMMUTABLE STABLE functions, daily updates
From: Sorin Dudui <sd@xxxxxxxxxxxx>
Date: Thu, 10 Nov 2011 13:05:56 +0000
Accept-language: de-DE, de-AT, en-US
Thread-index: AcyfqXVEN7dUSBKXQAOTfXScdYHHmQ==
Thread-topic: IMMUTABLE STABLE functions, daily updates

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

Follow-Ups:
- Re: IMMUTABLE STABLE functions, daily updates
  - From: Thom Brown

Prev by Date: Re: Subquery in a JOIN not getting restricted?
Next by Date: Re: IMMUTABLE STABLE functions, daily updates
Previous by thread: : bg_writer overloaded ?
Next by thread: Re: IMMUTABLE STABLE functions, daily updates
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux