Connections "Startup"

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Connections "Startup"
Date: 2015-12-22 07:59:27
Message-ID: CANYYVqLLTzEC5qEoex3dqDzmWM_tizxiygWWO1VJ-Wt4XLBqzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Hi.

I've noticed huge decrease in performance.
During this in htop i see a lot (200 - 300) of connections in state
"startup", each of them eats 3-3% of CPU time. This processes are not
visible in pg_stat_activity so i cant understand what they are doing, and i
cant kill them. I cant see the bottleneck in Disk IO to. The logs of
postgres says nothing to. I am confused.....
What can be the cause of huge amount of "startup" connections....
Maybe its better to start use connection pooler such as pgbouncer?
Thanks a lot.

PS.
Server config is:
2 * Intel Xeon 2660 CPU with 64 gigs of RAM.
Hardware RAID10.
Centos 6.6, PostgreSQL 9.1.2

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pavel Stehule 2015-12-22 08:09:18 Re: Connections "Startup"
Previous Message Michał Nowak 2015-12-21 13:18:20 Re: semop hanging - Postgres 9.4.4

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2015-12-22 08:09:18 Re: Connections "Startup"
Previous Message Jim Nasby 2015-12-20 23:08:04 Re: Can't explain db size