Postgres Pro
Downloads
Home   >   mailing lists

how much volatile is a function - Mailing list pgsql-general

From Anibal David Acosta
Subject how much volatile is a function
Date
Msg-id 001501cd605d$999e0ef0$ccda2cd0$@devshock.com
Whole thread Raw
Responses Re: how much volatile is a function  ("David Johnston" <polobo@yahoo.com>)
Re: how much volatile is a function  (Sergey Konoplev <sergey.konoplev@postgresql-consulting.com>)
List pgsql-general
Tree view

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 if the call has same parameters?

 

Thanks!

 

pgsql-general by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: PostgreSQL limitations question
Next
From: "David Johnston"
Date:
Subject: Re: how much volatile is a function