[Serusers] SER and cpu usage

[Chia Huey Lim]

Thanks Klaus. It's really postgres that's causing problem, after VACUUM and
reindexing the tables, CPU usage is now normal even during binding.

Regards,
Chia

-----Original Message-----
From: Klaus Darilion [mailto:klaus.mailinglists at pernau.at] 
Sent: Wednesday, October 05, 2005 3:21 PM
To: Chia Huey Lim
Cc: serusers at lists.iptel.org
Subject: Re: [Serusers] SER and cpu usage

I never had any problem with ser, but with postgres. Sometimes, (if you 
forget to VACUUM postgres or if the index of the tables is corrupt) 
postgres will consume a lot of CPU.

klaus

Chia Huey Lim wrote:
> Hi,
> 
>  
> 
> I am using ser 0.9.3 and postgresql with db mode 2.
> 
> There is a very serious problem when SER is binding users. Each SER PID 
> takes around 11% to 13% of CPU, which add up to be 99.x%
> 
> And at that time, no one can REGISTER, no one can INVITE etc.
> 
> Anyone experience that before?
> 
>  
> 
> Regards,
> 
> Chia
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers