From owner-freebsd-amd64@FreeBSD.ORG Tue Sep 6 00:00:38 2005 Return-Path: X-Original-To: freebsd-amd64@freebsd.org Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1B8F416A420 for ; Tue, 6 Sep 2005 00:00:38 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from fileserver.fields.utoronto.ca (fileserver.fields.utoronto.ca [128.100.216.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id E0B9F43D62 for ; Tue, 6 Sep 2005 00:00:18 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from fields.fields.utoronto.ca (fields.localdomain [192.168.216.11]) by fileserver.fields.utoronto.ca (8.12.8/8.12.8/Fields 6.0) with ESMTP id j8600Ivf001015 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 5 Sep 2005 20:00:18 -0400 Received: from obsecurity.dyndns.org (localhost.localdomain [127.0.0.1]) by fields.fields.utoronto.ca (8.12.8/8.12.8/Fields WS 6.0) with ESMTP id j8600H6P017287; Mon, 5 Sep 2005 20:00:17 -0400 Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 31620512E0; Mon, 5 Sep 2005 20:00:17 -0400 (EDT) Date: Mon, 5 Sep 2005 20:00:16 -0400 From: Kris Kennaway To: Claus Guttesen Message-ID: <20050906000016.GA91835@xor.obsecurity.org> References: <4316A5BC.1000405@meijome.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AhhlLboLdkugWU4S" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i Cc: freebsd-amd64@freebsd.org Subject: Re: Which SCHED_ for DB server X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Sep 2005 00:00:38 -0000 --AhhlLboLdkugWU4S Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Sep 01, 2005 at 10:53:39AM +0200, Claus Guttesen wrote: > > I'm building a server that will run PostgreSQL with a database > > containing several 10s of million records. The only things happening on > > this box will be the SQL processes and other processes to parse raw data > > and load into the DB. Users =3D a few connections via HTTP from an > > intranet server (not more than 5 concurrently). > >=20 > > I was wondering what is the best SCHED_ to set in the kernel. > > I currently have SCHED_4BSD but was wondering if _ULE would be better > > for this >=20 > For prod. use I would recommend SCHED_4BSD atm. The 4BSD-scheduler > does seem to be more stable on SMP and up. ULE might be OK on SMP with 6.0 and above, but performance seems to be a bit lower than 4BSD in my tests. Try it yourself and see which is better. Kris --AhhlLboLdkugWU4S Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQFDHNwQWry0BWjoQKURAkXpAKC2r4WkjyPr3JWoQKa8e7Wdek6DMwCfR1m4 PMhEHTvSd2s48Oj9Ry1jRXw= =UY1L -----END PGP SIGNATURE----- --AhhlLboLdkugWU4S--