From owner-freebsd-database@FreeBSD.ORG  Mon May 29 15:44:41 2006
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 [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DA65216AF7A
	for <freebsd-database@FreeBSD.org>;
	Mon, 29 May 2006 15:44:41 +0000 (UTC)
	(envelope-from girgen@FreeBSD.org)
Received: from banan.pingpong.net (banan.pingpong.net [213.136.40.205])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3B69143D46
	for <freebsd-database@FreeBSD.org>;
	Mon, 29 May 2006 15:44:30 +0000 (GMT)
	(envelope-from girgen@FreeBSD.org)
Received: from rambutan.pingpong.net (rambutan.pingpong.net [192.168.1.187])
	by banan.pingpong.net (8.13.6/8.13.6) with ESMTP id k4TFi2Ji002974;
	Mon, 29 May 2006 17:44:02 +0200 (CEST)
	(envelope-from girgen@FreeBSD.org)
Received: from localhost (localhost [127.0.0.1])
	by rambutan.pingpong.net (8.13.6/8.13.6) with ESMTP id k4TFi2P0061360; 
	Mon, 29 May 2006 17:44:02 +0200 (CEST)
	(envelope-from girgen@FreeBSD.org)
Date: Mon, 29 May 2006 17:44:02 +0200
From: Palle Girgensohn <girgen@FreeBSD.org>
To: postgresql-admin@postgresql.org, freebsd-database@FreeBSD.org
Message-ID: <D542F1895C3EAEC10F102B03@rambutan.pingpong.net>
X-Mailer: Mulberry/3.1.6 (Linux/x86)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Cc: 
Subject: Suggestion for a very fast postgresql machine?
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: Mon, 29 May 2006 15:44:52 -0000

Hi!

Do you have any suggestions for building a really fast machine with the 
sole purpose of running postgresql for a multi user application? The 
database currently has a 11 GB footprint on the disk.

I'm thinking in terms of at least four CPU:s, 12 GB RAM. Hardware is mostly 
a matter of money, I guess, and disks are probably the bottleneck, right? 
We are currently a FreeBSD only shop, we have very good knowledge about 
that system, and no experience with Linux. Still, is FreeBSD 6.1 a good 
choice, or will a Linux distribution outperform for 4+ SMP? I won't have 
much time to experiment, unfortunately, but I'd love some pointers or tips.

Thanks
Palle