Postgres Pro
Downloads
Home   >   mailing lists

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

From Huang, Suya
Subject Re: DB sessions 100 times of DB connections
Date
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CD014B3742@AUX1EXC01.apac.experian.local
Whole thread Raw
In response to DB sessions 100 times of DB connections  ("Huang, Suya" <Suya.Huang@au.experian.com>)
Responses Re: DB sessions 100 times of DB connections
List pgsql-performance
Tree view

BTW, I’m using the pgbadger report to check for peak connections/sessions.

 

From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Huang, Suya
Sent: Friday, July 04, 2014 11:44 AM
To: pgsql-performance@postgresql.org
Subject: [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

pgsql-performance by date:

Previous
From: "Huang, Suya"
Date:
Subject: DB sessions 100 times of DB connections
Next
From: piuschan
Date:
Subject: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary