Thread: Save prepared plan...
Is there around any way to save a prepared plan in postgresql?
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
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
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