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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] 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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly