Re: [GENERAL] Application crashing due to idle connection

2014-06-17 Thread David G Johnston
itishree sukla wrote > Our application is crashing... It really does help to be more specific with statements of this nature. In particular: 1) exactly how many idle connections (and are any of them idle in transaction)? You ran the queries - provide the numbers reported to you. 2) how many con

[GENERAL] Application crashing due to idle connection

2014-06-17 Thread itishree sukla
Hi all, Our application is crashing due to lot of idle connection from last 1 month it is very frequent. When i checked pg_stat_activity I found below query :SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid: is on idle state number of time.