From owner-freebsd-stable Tue Jun 18 19:28:52 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mail.redshift.com (mail.redshift.com [216.228.2.86]) by hub.freebsd.org (Postfix) with ESMTP id 5946737B401 for ; Tue, 18 Jun 2002 19:28:47 -0700 (PDT) Received: from atrustrivalie.org (pm1-17.corp.redshift.com [216.228.4.17]) (authenticated bits=0) by mail.redshift.com (8.12.3/8.12.3) with ESMTP id g5J2SNFr012356; Tue, 18 Jun 2002 19:28:29 -0700 Message-ID: <3D0FEC31.3000005@atrustrivalie.org> Date: Tue, 18 Jun 2002 19:28:01 -0700 From: Yann Ramin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0) Gecko/20020530 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jarrod Sayers Cc: "'stable@freebsd.org'" , "'buga@lemis.com'" Subject: Re: PostgreSQL 7.2 hanging CPU References: X-Enigmail-Version: 0.62.3.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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 -----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