Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 23 Oct 2006 20:15:04 -0400
From:      David Magda <dmagda@ee.ryerson.ca>
To:        Chuck Swiger <cswiger@mac.com>
Cc:        Mike Jakubik <mikej@rogers.com>, stable@freebsd.org
Subject:   Re: Running large DB's on FreeBSD
Message-ID:  <5FE48A6B-DD60-4FED-B925-C47CA555E962@ee.ryerson.ca>
In-Reply-To: <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
References:  <453D49D2.1010705@rogers.com> <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>

next in thread | previous in thread | raw e-mail | index | archive | help

On Oct 23, 2006, at 19:10, Chuck Swiger wrote:

> Moderately...it kinda depends on the budget available.  I regard  
> Solaris + Oracle as one of the most reliable combinations for  
> moderate to extreme load, for a system that might well be in  
> operation for five to ten years.  If I was going to do FreeBSD, I  
> might look into Postgres instead of MySQL; well, I might look into  
> something else than MySQL under many circumstances.  I've gotten  
> some pretty good use out of OpenBase, for another choice.

FWIW, Solaris 10 Update 3 (6/06) comes with Postres on the DVDs and  
you can get official support from Sun if that's important. Solaris/ 
x86 does run on HP hardware (with support available), but I don't the  
exact HCL offhand.

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/




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5FE48A6B-DD60-4FED-B925-C47CA555E962>