Execution plan caching - Mailing list pgsql-general

From Oliver Kohll
Subject Execution plan caching
Date
Msg-id 200207270151.25799.oliver@gtwebmarque.com
Whole thread Raw
Responses Re: Execution plan caching
List pgsql-general
Hi,
Does anyone know whether postgres caches its execution plans,
http://www.saturn5.com/~jwb/dbi-performance.html#stage2 ?

Hope so because I've just changed all of the queries in my code to use DBI's
bind_param. If not, will be useful if we ever port to Oracle anyway ;-)

If so, is the cache per db connection or does it remain across disconnects and
connects, i.e. will I have to use mod_perl to get the most advantage?

--
Regards,
Oliver
www.gtwebmarque.com

pgsql-general by date:

Previous
From: "Yuriy S. Polyakov"
Date:
Subject: _return double dimension array (table) from PLpgSQL procedure
Next
From: Joe Conway
Date:
Subject: Re: Advice on geolocation