From owner-freebsd-database@FreeBSD.ORG  Thu Mar 15 23:38:25 2007
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 A644416A400
	for <freebsd-database@freebsd.org>;
	Thu, 15 Mar 2007 23:38:25 +0000 (UTC)
	(envelope-from janm@transactionware.com)
Received: from mail.transactionware.com (mail.transactionware.com
	[203.14.245.7]) by mx1.freebsd.org (Postfix) with SMTP id E2D8013C44B
	for <freebsd-database@freebsd.org>;
	Thu, 15 Mar 2007 23:38:24 +0000 (UTC)
	(envelope-from janm@transactionware.com)
Received: (qmail 37523 invoked from network); 15 Mar 2007 23:12:03 -0000
Received: from midgard.transactionware.com (192.168.1.55)
	by dm.transactionware.com with SMTP; 15 Mar 2007 23:12:03 -0000
Received: (qmail 59041 invoked by uid 907); 15 Mar 2007 23:11:41 -0000
Received: from midgard.transactionware.com (HELO jmlaptop) (192.168.1.55)
	by midgard.transactionware.com (qpsmtpd/0.32) with ESMTP;
	Fri, 16 Mar 2007 10:11:41 +1100
From: "Jan Mikkelsen" <janm@transactionware.com>
To: "'Axel Rau'" <Axel.Rau@Chaos1.DE>, <freebsd-amd64@freebsd.org>,
	<freebsd-database@freebsd.org>
Date: Fri, 16 Mar 2007 10:11:40 +1100
Message-ID: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.6822
In-Reply-To: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
Thread-Index: AcdnUZHUi/lpZ5i9TD6DEoK3hNnjZAABK/bg
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
Importance: Normal
Cc: 
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
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 15 Mar 2007 23:38:25 -0000

Hi,

Axel Rau wrote:
 
> 1. Are there any precautions in fbsd to prevent from excessive page  
> switching between the memory nodes?
>     E.g. what happens if file cache pages (heavily used by Pg,  
> planned 6GB) frequently not found on local node?

Not that I'm aware of.  FreeBSD doesn't have NUMA awareness.

> 2. If there is no good solution for this problem, does it make sense  
> to stay with one dualcore (soon quadcore) processor?

Benchmark and see.

> 4. Can I install the system on an Areca raid?

Yes.  If you are planning to use 6.2-RELEASE, make sure that you get the
arcmsr driver from 6-STABLE.  The arcmsr driver in 6.2-RELEASE can show
I/O errors under high load.

Regards,

Jan Mikkelsen