statement stuck when the connection grew up to 45 or more
От
kah_hang_ang@toray.com.my
Тема
statement stuck when the connection grew up to 45 or more
Дата
Msg-id
OFD5C84655.E4EC8280-ON4825717E.000D636C@pengroup.com.my
Список
Дерево обсуждения
Re: statement stuck when the connection grew up to 45 or more kah_hang_ang@toray.com.my
Hi,
I'm using Postgresql 8.1.3.
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.
Could anyone give me some idea how could this be?
Is it a bug of PostgreSQL?
This is the statement which having problem:
select count(distinct empno) as counter1 from pay_master_history
where empno in (select empno from pay_batch_basic_history where
organizationid like '015003%')
and processyear = '2006'
and processmonth = '05'
and processbatch = '1'
Thanks!В списке pgsql-bugs по дате отправления