Sudden connection and load average spikes with postgresql 9.3

From: eudald_v <reaven(dot)galaeindael(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Sudden connection and load average spikes with postgresql 9.3
Date: 2015-06-30 14:52:16
Message-ID: 1435675936590-5855895.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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)
maintenance_work_mem: 256Mb
effective_cache_size: 340Gb

The database is running under postgresql 9.3.9 on an Ubuntu Server 14.04 LTS
(build 3.13.0-55-generic)

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 is relatively low (70Gb used), cores
activity is lower than usual and sometimes swap happens (I've swappiness
configured to 10%)

I've been trying to find the cause of this server underperformance, even
logging all queries in debug mode, but nothing strange found so far.

I really don't know which can be my next step to try to isolate the problem
and that's why I write to you guys. Have you ever seen this behaviour
before?
Could you kindly help me suggesting any step to follow?

Thanks and best regards!
E.v.

--
View this message in context: http://postgresql.nabble.com/Sudden-connection-and-load-average-spikes-with-postgresql-9-3-tp5855895.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2015-06-30 15:37:20 Re: Sudden connection and load average spikes with postgresql 9.3
Previous Message Josh Berkus 2015-06-27 19:29:23 Does anyone have python code which digests pgbench -r output?