Date: Tue, 18 Jun 2002 19:28:01 -0700 From: Yann Ramin <atrus@atrustrivalie.org> To: Jarrod Sayers <Jarrod.Sayers@unisa.edu.au> Cc: "'stable@freebsd.org'" <stable@freebsd.org>, "'buga@lemis.com'" <buga@lemis.com> Subject: Re: PostgreSQL 7.2 hanging CPU Message-ID: <3D0FEC31.3000005@atrustrivalie.org> References: <E1962E8F1DF0D411878300A0C9ACB0F90434D412@exstaff4.magill.unisa.edu.au>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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/DOGBERT 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?3D0FEC31.3000005>