> I've looked at PREPARE, but apparently it only lasts
> per-session - that's worthless in our case (web based
> service, one connection per data-requiring connection).
That's a non-sequitur. Most 'normal' high volume web apps have persistent
DB connections, one per http server process. Are you really dropping DB
connections and reconnecting each time a new HTTP request comes in?
In response to
pgsql-performance by date
|Next:||From: Gaetano Mendola||Date: 2004-09-23 17:40:32|
|Subject: Re: Caching of Queries|
|Previous:||From: Tom Lane||Date: 2004-09-23 17:35:47|
|Subject: Re: Caching of Queries |