From owner-freebsd-performance@FreeBSD.ORG  Tue Mar 23 12:49:35 2004
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
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 26FBE16A4CE
	for <freebsd-performance@freebsd.org>;
	Tue, 23 Mar 2004 12:49:35 -0800 (PST)
Received: from web14102.mail.yahoo.com (web14102.mail.yahoo.com
	[216.136.172.132])
	by mx1.FreeBSD.org (Postfix) with SMTP id EEE4E43D55
	for <freebsd-performance@freebsd.org>;
	Tue, 23 Mar 2004 12:49:34 -0800 (PST)
	(envelope-from cguttesen@yahoo.dk)
Message-ID: <20040323204927.35614.qmail@web14102.mail.yahoo.com>
Received: from [194.248.174.33] by web14102.mail.yahoo.com via HTTP;
	Tue, 23 Mar 2004 21:49:27 CET
Date: Tue, 23 Mar 2004 21:49:27 +0100 (CET)
From: =?iso-8859-1?q?Claus=20Guttesen?= <cguttesen@yahoo.dk>
To: Jason Coene <jcoene@gotfrag.com>, freebsd-performance@freebsd.org
In-Reply-To: <200403232002.i2NK2Gam077177@mail.gotfrag.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Subject: Re: FreeBSD, PostgreSQL, semwait and sbwait!
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 23 Mar 2004 20:49:35 -0000

> We're having a substantial problem with our FreeBSD
> 5.2 database server
> running PostgreSQL - it's getting a lot of traffic
> (figure about 3,000
> queries per second), but queries are slow, and it's
> seemingly waiting on
> other things than CPU time.
> ...
> It seems that queries are executing fine once they
> start, but it's taking a
> while for them to get going, while the postgres

It may not apply, but is DNS configured correct? Try
connect with ssh and see if it takes a few sec's
before you connect.

Your postgres-info seems fine.

As a sidenote you may want to copy GENERIC to a new
file and compile that one instead. During your next
cvsup GENERIC will be recovered to it's original state
and your changes will be lost.

regards
Claus


Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads, spamfilter og virusscan