DB sessions 100 times of DB connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
Subject: DB sessions 100 times of DB connections
From: "Huang, Suya" <Suya.Huang@xxxxxxxxxxxxxxx>
Date: Fri, 4 Jul 2014 01:44:02 +0000
Accept-language: en-US
Thread-index: Ac+XKWNfpFncUGDcQDOLoZhX0WMk+A==
Thread-topic: [PERFORM] DB sessions 100 times of DB connections

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

Follow-Ups:
- Re: DB sessions 100 times of DB connections
  - From: Huang, Suya

Prev by Date: Re: Hash Join node sometimes slow
Next by Date: Re: DB sessions 100 times of DB connections
Previous by thread: Hash Join node sometimes slow
Next by thread: Re: DB sessions 100 times of DB connections
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux