From owner-freebsd-stable Tue Jun 18 19:43: 1 2002 Delivered-To: freebsd-stable@freebsd.org Received: from exstaff9.city.unisa.edu.au (exstaff9.city.unisa.edu.au [130.220.84.77]) by hub.freebsd.org (Postfix) with ESMTP id F0AFF37B409 for ; Tue, 18 Jun 2002 19:42:53 -0700 (PDT) Received: by exstaff9.city.unisa.edu.au with Internet Mail Service (5.5.2655.55) id ; Wed, 19 Jun 2002 12:12:52 +0930 Message-ID: From: Jarrod Sayers To: 'Yann Ramin' Cc: "'stable@freebsd.org'" Subject: RE: PostgreSQL 7.2 hanging CPU Date: Wed, 19 Jun 2002 12:12:50 +0930 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-Type: text/plain Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Yann, The CPU usage hangs around 100% when the monitoring service updates all status fields for each node. This system was running on 4.5-STABLE with a slightly older version of PostgreSQL and had no problems with load - only after the system was cvsupped and ports updated. At the moment, it would do about 35 record updates a minute, changing one field in each record. I also had a cron job to vacuum the database hourly and that didn't help - as you can see by the graph, it still went silly over night. The data directory is currently about 116mb. I think it is a PostgreSQL problem too.. -Jarrod. > -----Original Message----- > From: Yann Ramin [mailto:atrus@atrustrivalie.org] > Sent: Wednesday, 19 June 2002 11:58 AM > To: Jarrod Sayers > Cc: 'stable@freebsd.org'; 'buga@lemis.com' > Subject: Re: PostgreSQL 7.2 hanging CPU > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > I've been running a PostgreSQL/mod_perl system for a long > time, recently > running on a dual PIII-733 under 4.6-STABLE. Some things to check: > > - - does this app do a lot of update/deletes ? > - - how big does the data directory get? > > Your database may need vacuuming. Seems more like a Postgres problem. > > Jarrod Sayers wrote: > | On a system running 4.6-R with all its packages upgraded by > portupgrade there > | appears to be a problem with PostgreSQL. A monitoring program is > started up > | when the machine boots which monitors machines on our > network and uses > | PostgreSQL to keep all its data. The problem is, is that > the load on the > | machine slowly grows (see > | http://dogbert.magill.unisa.edu.au/admin/mrtg/load.html) until the > machine is > | rebooted manually - at which stage the load begins around > 0.70. If I > reinstall > | PostgreSQL, re init the db and restore the data, the load > sits at 0.01 but > | after a few hours, its back to hanging the CPU. > | > | PID USERNAME PRI NICE SIZE RES STATE TIME WCPU > CPU COMMAND > | 8366 pgsql 64 0 6112K 3956K RUN 0:27 94.40% > 69.97% postgres > | > | dogbert> uname -a > | FreeBSD dogbert.magill.unisa.edu.au 4.6-RELEASE FreeBSD 4.6-RELEASE > #14: Mon > | Jun 10 12:03:12 CST 2002 > | > sayersjm@dogbert.magill.unisa.edu.au:/usr/src/sys/compile/DOGB > ERT i386 > | dogbert> ls -1 /var/db/pkg | grep postgres > | postgresql-7.2.1_1 > | dogbert> > | > | Any ideas on what causes it and how to fix it? > | > | Cheers, > | > | Jarrod Sayers > | Information Technology Services Unit > | University of South Australia, Mawson Lakes Campus. > | Phone: +61 8 8302 3133 > | http://people.unisa.edu.au/jarrod.sayers > | > | To Unsubscribe: send mail to majordomo@FreeBSD.org > | with "unsubscribe freebsd-stable" in the body of the message > > > > - -- > - ---------------------------------------------------------- > Yann Ramin atrus@atrustrivalie.org > Atrus Trivalie Productions > > Currently working in Wintendo. Signature very boring :( > Key ID: B790A0EC > Fingerprint: > 3E2F FFBC B244 BFF6 C089 7AE3 940D 1037 B790 A0EC > - ---------------------------------------------------------- > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6-2 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAj0P7DEACgkQlA0QN7eQoOwk9ACggNA3TFKyyYrgoQpmDgZx0807 > KAcAmwREM8cyZ7GMaCdGBRLKVD8xJp4T > =zaWa > -----END PGP SIGNATURE----- > > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message