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

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)
Date: 2011-09-09 21:04:55
Message-ID: CAGTBQpYi2kKiZhOfsa+zgHJ+s_DWq_Ueopd=995-X9XeB8RXVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Sep 9, 2011 at 5:38 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-09-09 21:05:36 Re: Migrated from 8.3 to 9.0 - need to update config (re-post)
Previous Message Kevin Grittner 2011-09-09 20:29:48 Re: PostgreSQL insights: does it use DMA?