<kah_hang_ang(at)toray(dot)com(dot)my> wrote
>
> Recently I facing one problem, when the connection for postgresql grow
> up
> 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
> again
> 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
> statement
> 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.
Regards,
Qingqing