Re: statement stuck when the connection grew up to 45 or more

<kah_hang_ang@toray.com.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