"Jan Cruz"
> <[EMAIL PROTECTED]> To: "Qingqing
Zhou" <[EMAIL PROTECTED]>
> Sent by: cc:
pgsql-bugs@postgresql.org
> [EMAIL PROTECTED]Subject: Re:
> Sent by:cc:
> pgsql-bugs@postgresql.org
> [EMAIL PROTECTED]
Sent by:cc:
pgsql-bugs@postgresql.org
[EMAIL PROTECTED] Subject: Re: [BUGS] statement
stuck when the connection grew up to 45 or more
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 whereorganizationid like '015003%')
and processyear = '2006' and processmonth = '05' and processbatc
<[EMAIL PROTECTED]> 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 s
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.
Bu
