Re: Need help in performance tuning.

Поиск
Список
Период
Сортировка
От Samuel Gendler
Тема Re: Need help in performance tuning.
Дата
Msg-id AANLkTin4Q4APRnbJ85FRasU7n8LuhKibKYcGnexsEbTt@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help in performance tuning.  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: Need help in performance tuning.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> If you're not using a connection pool, start using one.
>
> Do you really need 100 *active* working query threads at one time? Because
> if you do, you're going to need a scary-big disk subsystem and a lot of
> processors.

I see this issue and subsequent advice cross this list awfully
frequently.  Is there in architectural reason why postgres itself
cannot pool incoming connections in order to eliminate the requirement
for an external pool?

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Need help in performance tuning.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Need help in performance tuning.