From owner-freebsd-performance@FreeBSD.ORG Mon Dec 6 19:31:48 2004 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B460416A4D0 for ; Mon, 6 Dec 2004 19:31:48 +0000 (GMT) Received: from web14121.mail.yahoo.com (web14121.mail.yahoo.com [66.163.171.112]) by mx1.FreeBSD.org (Postfix) with SMTP id 9542743D1D for ; Mon, 6 Dec 2004 19:31:48 +0000 (GMT) (envelope-from cguttesen@yahoo.dk) Received: (qmail 85707 invoked by uid 60001); 6 Dec 2004 19:31:48 -0000 Message-ID: <20041206193148.85705.qmail@web14121.mail.yahoo.com> Received: from [194.248.174.58] by web14121.mail.yahoo.com via HTTP; Mon, 06 Dec 2004 20:31:48 CET Date: Mon, 6 Dec 2004 20:31:48 +0100 (CET) From: Claus Guttesen To: Sean Chittenden In-Reply-To: <72207B58-4700-11D9-9EB9-000A95C705DC@chittenden.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cc: freebsd-performance@freebsd.org Subject: Re: postgresql on FreeBSD 5.3 and high load (solved) X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 06 Dec 2004 19:31:48 -0000 Problem solved. It's a bit embarassing, but it turned out that it was a script which caused the high load. The script did unfortunately not bail out when a required condition was not satisfied. It queried the postgresql-server, and one thing led to the other. I (re)wrote the script, and it's now working as intended. Sorry for the noise. Claus