>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