Re: Re[2]: [PERFORM] SMP on a heavy loaded database - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Date
Msg-id CAGTBQpb5=piqRdp8p-96mUOT25ppCABO9966pA6LEXHzz0PoJA@mail.gmail.com
Whole thread Raw
In response to Re[2]: [PERFORM] SMP on a heavy loaded database  (nobody nowhere <devnull@mail.ua>)
List pgsql-performance
On Fri, Jan 4, 2013 at 11:41 AM, nobody nowhere <devnull@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 one user
> over all cores.
>
> 64 php Fast-cgi processes over the Unix socket and about 20-30 over tcp

I guess that means the server isn't dedicated to postgres...

...have you checked which PID is using that core? Is it postgres-related?


pgsql-performance by date:

Previous
From: Charles Gomes
Date:
Subject: Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Next
From: nobody nowhere
Date:
Subject: Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database