Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3

2015-06-30 Thread Josh Berkus
On 06/30/2015 07:52 AM, eudald_v wrote: > Two days from now, I've been experiencing that, randomly, the connections > rise up till they reach max connections, and the load average of the server > goes arround 300~400, making every command issued on the server take > forever. When this happens, ram

Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3

2015-06-30 Thread eudald_v
Dear Tom, Thanks for your fast approach. First of all, yes, queries seems to take more time to process and they are like queued up (you can even see inserts with status waiting on top/htop). I didn't know about that connection tip, and I will absolutely find a moment to add a pg_pooler to reduce

Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3

2015-06-30 Thread Tom Lane
eudald_v writes: > This is my very first message to the Postgresql community, and I really hope > you can help me solve the trouble I'm facing. > I've an 80 core server (multithread) with close to 500GB RAM. > My configuration is: > MaxConn: 1500 (was 850) > Shared buffers: 188Gb > work_mem: 110

[PERFORM] Sudden connection and load average spikes with postgresql 9.3

2015-06-30 Thread eudald_v
Hello all, This is my very first message to the Postgresql community, and I really hope you can help me solve the trouble I'm facing. I've an 80 core server (multithread) with close to 500GB RAM. My configuration is: MaxConn: 1500 (was 850) Shared buffers: 188Gb work_mem: 110Mb (was 220Mb) mainte