From owner-freebsd-database@FreeBSD.ORG Thu Mar 15 22:29:09 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 8B9CB16A402; Thu, 15 Mar 2007 22:29:09 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id 50DF213C44B; Thu, 15 Mar 2007 22:29:09 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44) id 1HRyC3-0002cL-3n; Thu, 15 Mar 2007 23:13:07 +0100 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: quoted-printable Message-Id: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed To: freebsd-amd64@freebsd.org, freebsd-database@freebsd.org From: Axel Rau Date: Thu, 15 Mar 2007 23:13:03 +0100 X-Mailer: Apple Mail (2.752.2) Cc: Subject: 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: Thu, 15 Mar 2007 22:29:09 -0000 Hi, while configuring my 1st PostgreSQL box with dual Opterons (2212) on =20 FreeBSD, I have some questions: 1. Are there any precautions in fbsd to prevent from excessive page =20 switching between the memory nodes? E.g. what happens if file cache pages (heavily used by Pg, =20 planned 6GB) frequently not found on local node? 2. If there is no good solution for this problem, does it make sense =20 to stay with one dualcore (soon quadcore) processor? 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? 4. Can I install the system on an Areca raid? Thanks, Axel --------------------------------------------------------------------- Axel Rau, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0