Re: Separating bgwriter and checkpointer - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: Separating bgwriter and checkpointer
Date
Msg-id CAF6yO=3KynswdAuWmbMRmfOTm-LzCmPWWwweaHiSJ-GXo_9rZQ@mail.gmail.com
Whole thread Raw
In response to Re: Separating bgwriter and checkpointer  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Separating bgwriter and checkpointer
List pgsql-hackers
2011/9/20 Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>:
> On 20.09.2011 16:49, Magnus Hagander wrote:
>>
>> Isn't there also the advantage of that work put in two different
>> processes can use two different CPU cores? Or is that likely to never
>> ever come in play here?
>
> You would need one helluva I/O system to saturate even a single CPU, just by
> doing write+fsync.

The point of Magnus is valid. There are possible throttling done by
linux per node, per process/task.
Since ..2.6.37 (32 ?) I believe .. there are more temptation to have
have per cgroup io/sec limits, and there exists some promising work
done to have a better IO bandwith throttling per process.

IMO, splitting the type of IO workload per process allows the
administrators to have more control on the IO limits they want to have
(and it may help the kernels() to have a better strategy ?)

>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Back-branch releases upcoming this week
Next
From: Andrew Dunstan
Date:
Subject: Re: Back-branch releases upcoming this week