From: Gregory Stark <stark@enterprisedb.com>
To: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PREPARE and stuff
Date: Sat, 23 Jun 2007 23:02:25 +0100
Message-ID: <87myyq9vny.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <op.tud8ogmscigqcu@apollo13>
References: <op.tud8ogmscigqcu@apollo13>
"PFC" <lists@peufeu.com> writes:
> Suppose a web application with persistent database connections.
> I have some queries which take longer to plan than to execute !
There have periodically been discussions about a shared plan cache but
generally the feeling is that it would do more harm than good and there are no
plans to implement anything like that.
For a web application though you would expect to be executing the same queries
over and over again since you would be executing the same pages over and over
again. So just a regular prepared query ought to good for your needs.
You do not want to be reconnecting to the database for each page fetch.
Replanning queries is the least of the problems with that approach.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stark@enterprisedb.com, lists@peufeu.com
Subject: Re: PREPARE and stuff
In-Reply-To: <87myyq9vny.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox