Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?
Date: 2008-04-01 15:22:20
Message-ID: 2651.1207063340@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> I can't really appreciate the difference... or better... I think the
> difference may be that I can't take for granted the function will be
> cached if I delegate the choice to the optimiser.

You can take for granted that it won't be, because there is no function
cache in Postgres.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-04-01 15:42:36 Re: Using tables in other PostGreSQL database
Previous Message Pettis, Barry 2008-04-01 15:12:54 Re: Using tables in other PostGreSQL database