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.
Any idea? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: Jueves, 03 de Noviembre de 2005 02:13 p.m. To: Cristian Prieto Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Save prepared plan... Cristian Prieto wrote: > Is there around any way to save a prepared plan in postgresql? Save for how long? Save between sessions? Globally for all sessions? No, we have no capability for that, and we are not sure why someone would want that. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
