Re: Migrated from 8.3 to 9.0 - need to update config (re-post)

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Migrated from 8.3 to 9.0 - need to update config (re-post)
Дата
Msg-id CAGTBQpYi2kKiZhOfsa+zgHJ+s_DWq_Ueopd=995-X9XeB8RXVA@mail.gmail.com
обсуждение исходный текст
Ответ на Migrated from 8.3 to 9.0 - need to update config (re-post)  (Carlo Stonebanks <stonec.register@sympatico.ca>)
Ответы Re: Migrated from 8.3 to 9.0 - need to update config (re-post)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
On Fri, Sep 9, 2011 at 5:38 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> This is getting back to that issue of using only enough processes at
> one time to keep all the bottleneck resources fully utilized.  Some
> people tend to assuem that if they throw a few more concurrent
> processes into the mix, it'll all get done sooner.  There are a
> great many benchmarks which show otherwise.

On the other hand, in order to benefit from synchro scans and stuff
like that, one has to increase concurrency beyond what is normally
considered optimal.

I have an application that really benefits from synchro scans, but
from time to time, when planets are aligned wrong, the extra
concurrency does hurt.

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: PostgreSQL insights: does it use DMA?
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)