Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?
Date
Msg-id 2651.1207063340@sss.pgh.pa.us
Whole thread Raw
In response to optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
Ivan Sergio Borgonovo <mail@webthatworks.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

pgsql-general by date:

Previous
From: "Pettis, Barry"
Date:
Subject: Re: Using tables in other PostGreSQL database
Next
From: Sam Mason
Date:
Subject: Re: Using tables in other PostGreSQL database