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

Re: Caching of Queries (now with pgpool)

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Michael Adler <adler(at)pobox(dot)com>
Cc: Jason Coene <jcoene(at)gotfrag(dot)com>,"'Josh Berkus'" <josh(at)agliodbs(dot)com>,pgsql-performance(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Caching of Queries (now with pgpool)
Date: 2004-09-25 17:25:08
Message-ID: 4155A9F4.1010807@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Michael Adler wrote:
| 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

With his load will not change anything.


Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBVany7UpzwH2SGd4RAj9UAJ0SO3VE7zMbwrgdwPQc+HP5PHClMACgtTvn
KIp1TK2lVbmXZ+s62fpJ46U=
=sjT0
-----END PGP SIGNATURE-----


In response to

pgsql-performance by date

Next:From: Andrew DunstanDate: 2004-09-25 19:39:01
Subject: automated builds?
Previous:From: Gaetano MendolaDate: 2004-09-25 16:58:09
Subject: Re: Caching of Queries

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