2011/9/20 Heikki Linnakangas <heikki.linnakan...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers