Shams Khan wrote:
> Whenever the load of server increases, I find this query running in
which seems to me the reason. Is
> there any other way I can written in such a way so that it doesn't
hang up the entire process?
Oh, I see. Try to follow
http://wiki.postgresql.org/wiki/Slow_Query_Questions
i
Whenever the load of server increases, I find this query running in which
seems to me the reason. Is there any other way I can written in such a way
so that it doesn't hang up the entire process?
On Thu, Nov 15, 2012 at 2:24 PM, Albe Laurenz wrote:
> Shams Khan wrote:
> > There are few query I fo
Shams Khan wrote:
> There are few query I found at the time of monitoring below
>
> 00:54:43.574338 | 26952 | select a.actno,MAX(b.actid) as
actid,MAX(b.actname) as name,MAX(b.phone)
> as phone,MAX(b.email) as mail,MAX(a.subsno) as subs,MAX(t.pkgid
> ) as svcid,MAX(a.expirydt) as expirydt,MAX
Hi,
There are few query I found at the time of monitoring below
00:54:43.574338 | 26952 | select a.actno,MAX(b.actid) as
actid,MAX(b.actname) as name,MAX(b.phone) as phone,MAX(b.email) as
mail,MAX(a.subsno) as subs,MAX(t.pkgid
) as svcid,MAX(a.expirydt) as expirydt,MAX(d.domid) as
domid,MAX(
