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: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Bruce Momjian Sent: Jueves, 03 de Noviembre de 2005 02:13 p.m. To: Cristian Prieto Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxxxx | (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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
