| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-09-25 19:39:01 | automated builds? |
| Previous Message | Gaetano Mendola | 2004-09-25 16:58:09 | Re: Caching of Queries |