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

From Gaetano Mendola
Subject Re: Caching of Queries (now with pgpool)
Date
Msg-id 4155A9F4.1010807@bigfoot.com
Whole thread Raw
In response to Re: Caching of Queries (now with pgpool)  (Michael Adler <adler@pobox.com>)
List 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-----


pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Caching of Queries
Next
From: Bruce Momjian
Date:
Subject: Re: Cleaning up indexes