> Do you control the app? Nop Just I know how it's developed. > The app has a pooling component and you still are having problems, have > you looked at what the pooler is actually doing? As far as I know, the wildfly's jdbc pool. No really I don't know what are doing. I suspect that problem is that in DAO's not are closing the sessions or not beginning transactions properly. I going to ask them send me the logfile or I'll could verify the pool behavior. > Not sure what the above means. Are you saying the application you refer > to above has a history of not correctly closing connections or are you > talking in general terms about applications interacting with databases. Sorry, it's not like that, just was a comment, The problem I have is with a specific application. > I've attached two files that may be helpful to you. Melvin , Thanks for the scripts! I owe one! I have another question, I've was reading about the lock_timeout, Somehow this parameter will help or could affect all the behaviour? Thanks! ----- Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9-2222-PARSE-waiting-tp5968923p5969552.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
