On Thu, Jul 12, 2012 at 10:55 PM, Sergey Konoplev
wrote:
> On Thu, Jul 12, 2012 at 10:38 PM, Anibal David Acosta
> wrote:
>> Does postgres re run the query on each function call, or has some kind of
>> “flag” indicating that table as not been changed and return cached result of
>> a previous cal
On Thu, Jul 12, 2012 at 10:38 PM, Anibal David Acosta wrote:
> Does postgres re run the query on each function call, or has some kind of
> “flag” indicating that table as not been changed and return cached result of
> a previous call if the call has same parameters?
It does re-run it on each call
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Anibal David Acosta
Sent: Thursday, July 12, 2012 2:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how much volatile is a function
I have a table, this table are rarely changed (added or
I have a table, this table are rarely changed (added or deleted).
My function receive parameters and do a query to the table.
Does postgres re run the query on each function call, or has some kind of
"flag" indicating that table as not been changed and return cached result of
a previous call i
