Re: [PERFORM] How to find the culprit in server load spikes?

2015-07-22 Thread Jeff Janes
On Wed, Jul 22, 2015 at 5:50 AM, Moreno Andreo wrote: > Hi everyone, > I host a Postgresql server on Ubuntu 12.04 and I am facing server load > spikes (if I run top, it goes up to 25-30 on a 4-core system)... > In some cases, I have to restart potgresql service because users call us > complai

Re: [PERFORM] How to find the culprit in server load spikes?

2015-07-22 Thread Kevin Grittner
Moreno Andreo wrote: > I host a Postgresql server on Ubuntu 12.04 and I am facing server > load spikes (if I run top, it goes up to 25-30 on a 4-core system)... > In some cases, I have to restart potgresql service because users call us > complaining of the slowness, but in some cases I can le

[PERFORM] How to find the culprit in server load spikes?

2015-07-22 Thread Moreno Andreo
Hi everyone, I host a Postgresql server on Ubuntu 12.04 and I am facing server load spikes (if I run top, it goes up to 25-30 on a 4-core system)... In some cases, I have to restart potgresql service because users call us complaining of the slowness, but in some cases I can leave things on