From: nobody nowhere <devnull@mail.ua>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
Date: Fri, 04 Jan 2013 20:23:46 +0400
Message-ID: <1357316626.426915913@f209.mail.ru> (raw)
References: <1357256708.822075673@f352.mail.ru>
<1357310485.759772865@f13.mail.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Пятница, 4 января 2013, 11:52 -03:00 от Claudio Freire <klaussfreire@gmail.com>:
>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?
How do I know it?
Only postgres on this server heavely use the Raid controller. PHP comletely in XCache. At night I'll try to change socket to tcp. May be it will help,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: devnull@mail.ua, klaussfreire@gmail.com
Subject: Re: Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
In-Reply-To: <1357316626.426915913@f209.mail.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox