From owner-freebsd-amd64@FreeBSD.ORG Fri Nov 11 15:18:13 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 A550816A41F for ; Fri, 11 Nov 2005 15:18:13 +0000 (GMT) (envelope-from vivek@khera.org) Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3BC1E43D49 for ; Fri, 11 Nov 2005 15:18:12 +0000 (GMT) (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 D185DB80A for ; Fri, 11 Nov 2005 10:18:11 -0500 (EST) Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: References: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Vivek Khera Date: Fri, 11 Nov 2005 10:18:10 -0500 To: freebsd-amd64 List X-Mailer: Apple Mail (2.746.2) Subject: Re: FreeBSD 5.4 or 6.0 as postgresql-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: Fri, 11 Nov 2005 15:18:13 -0000 On Nov 9, 2005, at 5:47 PM, Claus Guttesen wrote: > Since 6.0 just came out the door it may be premature to ask whether I > should go for RELENG_6_0 or 5.4 (RELENG_5). The server will only be > doing postgresql 7.4.9. Is anyone running postgresql with 8 GB RAM or > more on 6.0? > > Our current (and slightly smaller hardware-wise) db-server is running > RELENG_5_4 but I'd like to get the improved smp-, disk- and > network-related improvements in 6.0. I'm running 5.4-REL on Tyan K8SR boards with dual opterons at 4GB, LSI 320-2X RAID cards configured with a 2 disk RAID1 for system + PG log and 6 disk RAID10 for data. However, I do not run the onboard BGE nics. I use a plug-in Intel dual gigabit nic. We had some lockups with the bge onboard until we switched to the Intels. Postgres 8.0.4 runs non-stop and with great speed. I just took delivery (and will be putting into full-load pre- production testing today) a similar system (it has more disks is the major difference) with FreeBSD 6.0-REL. So far my experience with a couple of other 6.0/amd64 systems (one in production) has been positive. I don't anticipate any problems, but do expect some improvements in concurrency to the disk. I've been avoiding > 4GB RAM because of issues I hear others have been having, such as yours... One of these days I'll try it I'm sure.