Re: Caching of Queries (now with pgpool) - Mailing list pgsql-performance

From Michael Adler
Subject Re: Caching of Queries (now with pgpool)
Date
Msg-id 20040924020058.GA11703@pobox.com
Whole thread Raw
In response to Re: Caching of Queries (now with pgpool)  ("Jason Coene" <jcoene@gotfrag.com>)
Responses Re: Caching of Queries (now with pgpool)  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-performance
On Thu, Sep 23, 2004 at 09:23:51PM -0400, Jason Coene wrote:
> I ran some previous queries to get pgpool to pre-establish all the
> connections, and ab ran for a few minutes (with one query per page, eek!).
> It was still exhibiting the same problems as before.  While so many new
> connections at once can surely make the problem worse (and pgpool will
> surely help there), shouldn't this prove that it's not the only issue?

> Any ideas?

Now that your connections are persistent, you may benefit from using
PREPAREd queries.

-Mike

pgsql-performance by date:

Previous
From: "Jason Coene"
Date:
Subject: Re: Caching of Queries (now with pgpool)
Next
From: Mark Wong
Date:
Subject: Re: O_DIRECT setting