From owner-freebsd-stable@FreeBSD.ORG  Fri Oct 27 04:44:15 2006
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: stable@freebsd.org
Delivered-To: freebsd-stable@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1DD0D16A403
	for <stable@freebsd.org>; Fri, 27 Oct 2006 04:44:15 +0000 (UTC)
	(envelope-from decibel@decibel.org)
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 630DE43D67
	for <stable@freebsd.org>; Fri, 27 Oct 2006 04:44:08 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id 182CF56446; Thu, 26 Oct 2006 23:44:08 -0500 (CDT)
Received: (hashcash-sendmail, from uid 1001); Thu, 26 Oct 2006 23:44:03 -0500
Date: Thu, 26 Oct 2006 23:44:03 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: David Magda <dmagda@ee.ryerson.ca>
Message-ID: <20061027044403.GK26892@decibel.org>
References: <453D49D2.1010705@rogers.com>
	<3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
	<5FE48A6B-DD60-4FED-B925-C47CA555E962@ee.ryerson.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <5FE48A6B-DD60-4FED-B925-C47CA555E962@ee.ryerson.ca>
X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Hashcash: 1:20:061027:dmagda@ee.ryerson.ca::ZL4Cr14mcCYc42XZ:00000000000000000
	00000000000000000000000062Xn
X-Hashcash: 1:20:061027:cswiger@mac.com::EKNzt2TXJaPb+P2f:000sRC
X-Hashcash: 1:20:061027:mikej@rogers.com::wl0q5jN+zd4Ng2uf:0E/6H
X-Hashcash: 1:20:061027:stable@freebsd.org::6W3UP2XmSGBMyJaU:0000000000000000000
	0000000000000000000000002XTt
Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org
Subject: Re: Running large DB's on FreeBSD
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 27 Oct 2006 04:44:15 -0000

On Mon, Oct 23, 2006 at 08:15:04PM -0400, David Magda wrote:
> As for Postgres on FreeBSD, FlighAware seems to be using it some some  
> decent amount of data:
> 
> >. Receiving the data and processing it puts them about 6 minutes  
> >behind real time
> >. Generating one map can be done in about 160 milliseconds of CPU time
> >. Capable of generating several million maps a day
> >. About 1 TB of stored data
> >. Approximately 40 million position updates on air craft per day
> 
> http://joseph.randomnetworks.com/archives/2006/05/12/flightaware- 
> freebsd-and-postgresql/

And that's on a dual opteron with 12G of memory and a run of the mill
RAID10 (for the database that is).
-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"