| From: | nobody nowhere <devnull(at)mail(dot)ua> |
|---|---|
| To: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database |
| Date: | 2013-01-04 16:23:46 |
| Message-ID: | 1357316626.426915913@f209.mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Пятница, 4 января 2013, 11:52 -03:00 от Claudio Freire <klaussfreire(at)gmail(dot)com>:
>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?
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2013-01-04 16:43:16 | Re: Re[2]: [PERFORM] SMP on a heavy loaded database |
| Previous Message | nobody nowhere | 2013-01-04 15:56:28 | Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database |