Postgres Pro
Downloads
Home   >   mailing lists

DB sessions 100 times of DB connections - Mailing list pgsql-performance

From Huang, Suya
Subject DB sessions 100 times of DB connections
Date
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CD014B36E3@AUX1EXC01.apac.experian.local
Whole thread Raw
Responses Re: DB sessions 100 times of DB connections
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Dave Roberge
Date:
Subject: Re: Hash Join node sometimes slow
Next
From: "Huang, Suya"
Date:
Subject: Re: DB sessions 100 times of DB connections