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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
