DB sessions 100 times of DB connections

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: DB sessions 100 times of DB connections
Date: 2014-07-04 01:44:02
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD014B36E3@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

We've experienced a DB issue yesterday and after checked the log found that the peak sessions is 3000 while the peak DB connections is only around 30. The application is having problem of pulling data but no warnings in DB log as it doesn't exceed max_connections.

How could this happen? How does sessions/connections work in Postgres?

Thanks,
Suya

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Huang, Suya 2014-07-04 01:59:51 Re: DB sessions 100 times of DB connections
Previous Message Dave Roberge 2014-07-03 15:14:13 Re: Hash Join node sometimes slow