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
On Thu, Nov 03, 2005 at 10:01:30AM -0600, Cristian Prieto wrote:
Is there around any way to save a prepared plan in postgresql?
Save as in save in the database for other connections to use? It's not
very clear what you're asking...
--
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
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
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