Today is not the worse day for this issue, because Fridays DB have little
workload... But I have this output:
I don't have updated OS server from the install.
I also begin to think that the problem is OS misconfiguration (Kernel
parameters??) or Hardware problem...
Thanks for your help.
2012/10/30 Josh Berkus <josh(at)agliodbs(dot)com>
> > On this server I have only one database with 312GB of data. The database
> > had run fine during 4 months, but from two months ago, during high work
> > load periods, the server is collapsed by "%sys" type load.
> Hmmm. Have you updated Linux any time recently? I'm wondering if this
> is a PostgreSQL problem at all. It sounds like an OS issue.
> Can you give us the results of mpstat -P ALL 3 ? The dstat output
> doesn't tell me much.
> Josh Berkus
> PostgreSQL Experts Inc.
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
César Martín Pérez
In response to
pgsql-performance by date
|Next:||From: Ants Aasma||Date: 2012-11-02 11:27:40|
|Subject: Re: dbt2 performance regresses from 9.1.6 to 9.2.1|
|Previous:||From: Scott Marlowe||Date: 2012-11-02 05:39:59|
|Subject: Re: Increasing work_mem and shared_buffers on Postgres 9.2
significantly slows down queries|