Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-09-23 17:40:32
Subject: Re: Caching of Queries
Previous:From: Tom LaneDate: 2004-09-23 17:35:47
Subject: Re: Caching of Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group