> Recently I facing one problem, when the connection for postgresql grow
> to 45 or more, when I trigger a statement from WebApp
> this statement will stuck forever.
> I try to kill this transaction and then trigger the same statement
> but it still the same.
> But this time I leave the transaction there and try to kill other
> connections that is not in use.
> It's weird that after I kill around 5-10 unused connections, the
> start to run and finish.
I can hardly believe that's Postgres's problem. Are you sure the query
was processing by the server? Try to do:
ps -auxw|grep postgres
to see if you can see the query was stuck there.
In response to
pgsql-bugs by date
|Next:||From: Stefan van Aalst||Date: 2006-06-02 06:29:00|
|Subject: Infinite increment of postgre.exe in taskmanager|
|Previous:||From: Stephen||Date: 2006-06-02 05:08:14|
|Subject: BUG #2462: pg_dump ftell mismatch error (cont'd)|