From owner-freebsd-performance@FreeBSD.ORG Wed Dec 1 22:23:29 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 A6D6116A4CE for ; Wed, 1 Dec 2004 22:23:29 +0000 (GMT) Received: from mail2.dbitech.ca (radius.wavefire.com [64.141.13.252]) by mx1.FreeBSD.org (Postfix) with SMTP id 25DC843D1D for ; Wed, 1 Dec 2004 22:23:29 +0000 (GMT) (envelope-from darcy@wavefire.com) Received: (qmail 25056 invoked from network); 1 Dec 2004 23:28:51 -0000 Received: from dbitech.wavefire.com (HELO ?64.141.15.253?) (darcy@64.141.15.253) by radius.wavefire.com with SMTP; 1 Dec 2004 23:28:51 -0000 From: Darcy Buskermolen Organization: Wavefire Technologies Corp. To: freebsd-performance@freebsd.org Date: Wed, 1 Dec 2004 14:23:27 -0800 User-Agent: KMail/1.6.2 References: <20041201105113.79348.qmail@web14102.mail.yahoo.com> <6174636A-43BC-11D9-ACAF-000A95C705DC@chittenden.org> In-Reply-To: <6174636A-43BC-11D9-ACAF-000A95C705DC@chittenden.org> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200412011423.27424.darcy@wavefire.com> cc: Claus Guttesen Subject: Re: postgresql on FreeBSD 5.3 and high load 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: Wed, 01 Dec 2004 22:23:29 -0000 On December 1, 2004 09:13 am, Sean Chittenden wrote: > > Our postgresql-server hits the wall when we get many > > hits on our web. The load-average reaches 70. It > > serves 11 webservers. > > Have you looked to see if you're using spin locks or not? Search for > "amd64 x86_64 spin lock" in PostgreSQL's archives. I think spin locks > were disabled for amd64. When you're at a load of 70, look in > pg_catalog.pg_locks to see if you have any ungranted locks. > > Also, is your application primarily read? You may want to investigate > using pgpool as a way of reducing the overhead for connection startup. > > Another option is to use memcached and remove some queries from the > database all together. -sc Umm I'm not sure where the misscommunication is (it could be at my end), but if I'm not mistalen a DELL 2850 is a dual Xeon EM64T box so all of the amd64 stuff is moot on this platform. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com