Date: Wed, 19 Jun 2002 12:12:50 +0930 From: Jarrod Sayers <Jarrod.Sayers@unisa.edu.au> To: 'Yann Ramin' <atrus@atrustrivalie.org> Cc: "'stable@freebsd.org'" <stable@freebsd.org> Subject: RE: PostgreSQL 7.2 hanging CPU Message-ID: <E1962E8F1DF0D411878300A0C9ACB0F90434D416@exstaff4.magill.unisa.edu.au>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E1962E8F1DF0D411878300A0C9ACB0F90434D416>