Re: Migrated from 8.3 to 9.0 - need to update config (re-post) - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Migrated from 8.3 to 9.0 - need to update config (re-post)
Date
Msg-id CAGTBQpYi2kKiZhOfsa+zgHJ+s_DWq_Ueopd=995-X9XeB8RXVA@mail.gmail.com
Whole thread Raw
In response to Migrated from 8.3 to 9.0 - need to update config (re-post)  (Carlo Stonebanks <stonec.register@sympatico.ca>)
Responses Re: Migrated from 8.3 to 9.0 - need to update config (re-post)
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL insights: does it use DMA?
Next
From: Claudio Freire
Date:
Subject: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)