Skip site navigation (1) Skip section navigation (2)

Gradual increase in CPU utilization by postmaster

From: "Rangachari Anand" <anand(at)reefedge(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Gradual increase in CPU utilization by postmaster
Date: 2001-06-20 19:59:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
We are running Postgres 7.0.3 on a Linux machine with a 2.4.0 kernel.

We have noticed that as we run our application which does
a lot of updates that CPU utilization (by postmaster) gradually 
increases as time passes.

We have been able to reproduce it with the following
shell script which we use to feed a continuous stream
of updates to the DB:


while ( true ) ; do

  echo "update ruser set cname='xyz' where userid='abcdef'; "


We connect it to psql to send the updates to the DB as follows:

./  | psql -U AAA DBNAME -q

When we start the script, the "top" command shows about 75%
CPU utilization but this gradually increases to 97%
in a few minutes.

Could anyone suggest a reason for this behavior?

R. Anand


pgsql-admin by date

Next:From: Rangachari AnandDate: 2001-06-20 20:03:40
Subject: High CPU utilization by postmaster
Previous:From: berger, ralfDate: 2001-06-20 18:41:28
Subject: AW: Re: JDBC in postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group