Re: Caching of Queries

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: "'Jason Coene'" <jcoene(at)gotfrag(dot)com>, "'Mr Pink'" <mr_pink_is_the_only_pro(at)yahoo(dot)com>, "'Scott Kirkwood'" <scottakirkwood(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Caching of Queries
Date: 2004-09-23 17:38:32
Message-ID: 002001c4a194$25481810$8300a8c0@solent
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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?

M

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-23 17:40:32 Re: Caching of Queries
Previous Message Tom Lane 2004-09-23 17:35:47 Re: Caching of Queries