From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 20:32:40 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E7B4F16A403; Fri, 16 Mar 2007 20:32:39 +0000 (UTC) (envelope-from vivek@khera.org) Received: from yertle.kcilink.com (yertle.kcilink.com [74.92.149.58]) by mx1.freebsd.org (Postfix) with ESMTP id 9710413C46A; Fri, 16 Mar 2007 20:32:39 +0000 (UTC) (envelope-from vivek@khera.org) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id 7595BB820; Fri, 16 Mar 2007 16:04:10 -0400 (EDT) In-Reply-To: References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-9-347238058; protocol="application/pkcs7-signature" Message-Id: <111EFCD1-0B88-4646-BCF5-B13D1F3BBCB0@khera.org> From: Vivek Khera Date: Fri, 16 Mar 2007 16:04:09 -0400 To: FreeBSD AMD list X-Mailer: Apple Mail (2.752.2) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-database@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Mar 2007 20:32:40 -0000 --Apple-Mail-9-347238058 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Mar 16, 2007, at 7:17 AM, Claus Guttesen wrote: >> while configuring my 1st PostgreSQL box with dual Opterons (2212) on >> FreeBSD, I have some questions: >> >> 3. What are the recommendations for tuning I/O)? >> - setting sysctl vfs.read_max to 16 or 32 >> - rebuilding the relevant filesystem with 32K blocks and 4K frags >> Are these reliable? > > The following were suggetions from Vivek Khera: I've recently bumped the shmall and shmmax on my dual opteron with 16GB of RAM, and increased correspondingly the shared buffers. The max shmall you can set on freebsd (at least 6.1) is 2147483647, so I set shmall to 524288 to correspond. This supports 250000 shared buffers and 100 max connections. Might support more, but definitely not 260000. I'm also using vfs.read_max=32 but I haven't really tested if it makes a big difference in formal benchmarks. The other day I was having some I/O overload, so I tried setting vfs.hirunningspace to 3K but it didn't solve my immediate problem. I've left that setting for now. Doesn't seem to really make a big difference. I find that the adaptec 2230SLP RAID controllers are not able to keep up with my load, but the LSI 320-2X is. I'm currently investigating external arrays attached via fibre for some boost. --Apple-Mail-9-347238058--