Re: PostgreSQL and Xeon MP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Guillaume Smet" <guillaume.smet@xxxxxxxxx> writes:
> Here is a top output I had on november 17 when the server completely
> hangs (several minutes for each page of the website) and it is typical
> of this server behaviour:
> 17:08:41  up 19 days, 15:16,  1 user,  load average: 4.03, 4.26, 4.36
> 288 processes: 285 sleeping, 3 running, 0 zombie, 0 stopped
> CPU states:  cpu    user    nice  system    irq  softirq  iowait    idle
>            total   59.0%    0.0%    8.8%   0.2%     0.0%    0.0%   31.9%
>            cpu00   52.3%    0.0%   13.3%   0.9%     0.0%    0.0%   33.3%
>            cpu01   65.7%    0.0%    7.6%   0.0%     0.0%    0.0%   26.6%
>            cpu02   58.0%    0.0%    7.6%   0.0%     0.0%    0.0%   34.2%
>            cpu03   60.0%    0.0%    6.6%   0.0%     0.0%    0.0%   33.3%
> Mem:  3857224k av, 3495880k used,  361344k free,       0k shrd,   92160k buff
>                    2374048k actv,  463576k in_d,   37708k in_c
> Swap: 4281272k av,   25412k used, 4255860k free                 2173392k cached

> As you can see, load is blocked to 4, no iowait and cpu idle of 30%.

Can you try strace'ing some of the backend processes while the system is
behaving like this?  I suspect what you'll find is a whole lot of
delaying select() calls due to high contention for spinlocks ...

			regards, tom lane


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux