Re: Caching of Queries (now with pgpool)
От | Gaetano Mendola |
---|---|
Тема | Re: Caching of Queries (now with pgpool) |
Дата | |
Msg-id | 4155A9F4.1010807@bigfoot.com обсуждение исходный текст |
Ответ на | Re: Caching of Queries (now with pgpool) (Michael Adler <adler@pobox.com>) |
Список | 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 по дате отправления: