Re: Re[2]: [PERFORM] SMP on a heavy loaded database

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: nobody nowhere <devnull(at)mail(dot)ua>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Date: 2013-01-04 14:52:10
Message-ID: CAGTBQpb5=piqRdp8p-96mUOT25ppCABO9966pA6LEXHzz0PoJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 4, 2013 at 11:41 AM, nobody nowhere <devnull(at)mail(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message nobody nowhere 2013-01-04 15:56:28 Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
Previous Message Charles Gomes 2013-01-04 14:47:51 Re: Re[2]: [PERFORM] SMP on a heavy loaded database