Re: Caching of Queries (now with pgpool)

Поиск
Список
Период
Сортировка
От Michael Adler
Тема Re: Caching of Queries (now with pgpool)
Дата
Msg-id 20040924020058.GA11703@pobox.com
обсуждение исходный текст
Ответ на Re: Caching of Queries (now with pgpool)  ("Jason Coene" <jcoene@gotfrag.com>)
Ответы Re: Caching of Queries (now with pgpool)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jason Coene"
Дата:
Сообщение: Re: Caching of Queries (now with pgpool)
Следующее
От: Mark Wong
Дата:
Сообщение: Re: O_DIRECT setting