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

From Tom Lane
Subject Re: Gradual increase in CPU utilization by postmaster
Date
Msg-id 13155.993133064@sss.pgh.pa.us
Whole thread Raw
In response to Re: Gradual increase in CPU utilization by postmaster  ("Yasuo Ohgaki" <yasuo_ohgaki@hotmail.com>)
List pgsql-admin
"Yasuo Ohgaki" <yasuo_ohgaki@hotmail.com> writes:
> Postmaster size and CPU time increases gradually as time passes.
> After 25 minutes elapsed, postmaster size became about 7000.
> CPU time increased to about 90% from 70%.

> Terminating script and executing again will result in the same higher
> CPU and memory usage.
> Vacuuming table seems to reset this behavior.

Wait a minute, are we talking about *postmaster* size or *backend* size?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Rangachari Anand"
Date:
Subject: RE: Gradual increase in CPU utilization by postmaster
Next
From: Tom Lane
Date:
Subject: Re: Problems upgrading from 7.1beta4 to 7.1.0