Fixed by
synchronous_commit = off
Суббота, 5 января 2013, 12:53 +04:00 от nobody nowhere :
> > > [ all postgres processes seem to be pinned to CPU 14 ]
> >
> > I wonder whether this is a "benefit" of sched_autogroup_enabled?
> >
> > http://archi
> > [ 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.9040...@optionshouse.com
>
> regards, tom lane
Thanks Lane
RHEL 5.x
:(
--
Sent via pgsq
Пятница, 4 января 2013, 18:53 -03:00 от Claudio Freire
:
>On Fri, Jan 4, 2013 at 6:38 PM, nobody nowhere < devn...@mail.ua > wrote:
>> On Fri, Jan 4, 2013 at 6:07 PM, nobody nowhere < devn...@mail.ua > wrote:
>>> 9092 postgres 16 0 4326m 41m 34m S 0.0 0.3 0:00.27
Пятница, 4 января 2013, 18:20 -03:00 от Claudio Freire
:
>On Fri, Jan 4, 2013 at 6:07 PM, nobody nowhere < devn...@mail.ua > wrote:
>> 9092 postgres 16 0 4326m 41m 34m S 0.0 0.3 0:00.27 14 postgres:
>> user user_db [local] idle
>> 9098 postgres 16 0
>Oh... and you can also tell top to show the "last used processor". I
>guess I should have said this first ;-)
Even if do not fix it, I'll know a new feature of top :)
Certainly sure 14 CPU
Total DISK READ: top - 21:54:38 up 453 days, 23:34, 1 user, load average:
0.56, 0.55, 0.48
Tasks: 429
Пятница, 4 января 2013, 11:52 -03:00 от Claudio Freire
:
>On Fri, Jan 4, 2013 at 11:41 AM, nobody nowhere < devn...@mail.ua > wrote:
>> So how many concurrent users are accessing this db? pgsql assigns one
>> process on one core so to speak. It can't spread load for
>>
>>
>>
>>
>> Пятница, 4 января 2013, 0:42 -07:00 от Scott Marlowe
>> < scott.marl...@gmail.com >:
>> On Thu, Jan 3, 2013 at 4:45 PM, nobody nowhere
>> http://sentmsg?compose&To=devnull%40mail.ua >> wrote:
>> > Cen
Пятница, 4 января 2013, 0:42 -07:00 от Scott Marlowe :
>On Thu, Jan 3, 2013 at 4:45 PM, nobody nowhere < devn...@mail.ua > wrote:
>> Centos 5.X kernel 2.6.18-274
>> pgsql-9.1 from pgdg-91-centos.repo
>> relatively small database 3.2Gb
>> Lot of insert, update,
Centos 5.X kernel 2.6.18-274
pgsql-9.1 from pgdg-91-centos.repo
relatively small database 3.2Gb
Lot of insert, update, delete.
I see non balanced _User_ usage on 14 CPU, exclusively assigned to the hardware
raid controller.
What I'm doing wrong, and is it possible somehow to fix?
Thanks in advan
