RE: Gradual increase in CPU utilization by postmaster - Mailing list pgsql-admin

From Rangachari Anand
Subject RE: Gradual increase in CPU utilization by postmaster
Date
Msg-id NHEMKEOEIKGALJPGOPLEEEOPCKAA.anand@reefedge.com
Whole thread Raw
In response to Re: Gradual increase in CPU utilization by postmaster  ("Yasuo Ohgaki" <yasuo_ohgaki@hotmail.com>)
List pgsql-admin

>Terminating script and executing again will result in the same higher
>CPU and memory usage.
>Vacuuming table seems to reset this behavior.
>
>I've used the same script as Anand, but I think this situation is
>common in HTTP session management. (Updating the same record
>again and again.) Session record would not be updated as this test
>case, though.
>
>It seems I'm better off vacuuming my session table more often.

I was also able to use vacuum to reset CPU utilization.
We are unable to upgrade to 7.1.2 immediately
so as a temporary fix, we have vacuumdb being invoked periodically by
crond.

Thanks for your help.

R. Anand


pgsql-admin by date:

Previous
From: "Mahesh Guleria"
Date:
Subject: Increasing the no. of users.
Next
From: Tom Lane
Date:
Subject: Re: Gradual increase in CPU utilization by postmaster