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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Caching of Queries
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Cleaning up indexes