Re: [PERFORM] DB sessions 100 times of DB connections

2014-07-08 Thread Steve Crawford
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 pullin

Re: [PERFORM] DB sessions 100 times of DB connections

2014-07-03 Thread Huang, Suya
M] 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 does

[PERFORM] DB sessions 100 times of DB connections

2014-07-03 Thread Huang, Suya
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? H