Re: Save prepared plan...

On Thu, Nov 03, 2005 at 03:22:34PM -0600, Cristian Prieto wrote:
> Save globally for all session or between sessions.
>
> Well, I have a set of queries which runs several times. My clients connect
> and execute it. But each time the client connects and disconnects, that
> means that I loose the execution plan. I would like the keep the execution
> plan between sessions that would improve the performance of the execution of
> my application.

If you're connecting and disconnecting frequently you probably want to
be using pgpool. Even if you're not, it would (mostly) satisfy what
you're trying to do here.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461