Re: SMP on a heavy loaded database FIXED !!!! - Mailing list pgsql-performance

From nobody nowhere
Subject Re: SMP on a heavy loaded database FIXED !!!!
Date
Msg-id 1357582217.586251208@f128.mail.ru
Whole thread Raw
In response to Re[2]: [PERFORM] Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database  (nobody nowhere <devnull@mail.ua>)
List pgsql-performance
Fixed by

synchronous_commit = off


Суббота,  5 января 2013, 12:53 +04:00 от nobody nowhere <devnull@mail.ua>:
> > > [ all postgres processes seem to be pinned to CPU 14 ]
> >
> > I wonder whether this is a "benefit" of sched_autogroup_enabled?
> >
> > http://archives.postgresql.org/message-id/50E4AAB1.9040902@optionshouse.com
> >
> >             regards, tom lane
>
> Thanks Lane
>
> RHEL 5.x
> :(
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

pgsql-performance by date:

Previous
From: Patrick Dung
Date:
Subject: Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS
Next
From: "ktm@rice.edu"
Date:
Subject: Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS