Date: Thu, 26 Oct 2006 23:44:03 -0500 From: "Jim C. Nasby" <decibel@decibel.org> To: David Magda <dmagda@ee.ryerson.ca> Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org Subject: Re: Running large DB's on FreeBSD Message-ID: <20061027044403.GK26892@decibel.org> In-Reply-To: <5FE48A6B-DD60-4FED-B925-C47CA555E962@ee.ryerson.ca> References: <453D49D2.1010705@rogers.com> <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com> <5FE48A6B-DD60-4FED-B925-C47CA555E962@ee.ryerson.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
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?"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20061027044403.GK26892>