Running large DB's on FreeBSD

[Nguyen Tam Chinh]

On Tue, 24 Oct 2006, Vivek Khera wrote:

>
> On Oct 23, 2006, at 7:01 PM, Mike Jakubik wrote:
>
>>   So, first of all, am i crazy for choosing fbsd+mysql for this rather than 
>> something like Solaris + Oracle? :) Secondly, i am just looking for some 
>> suggestions, opinions, success/failure story's that may help me out. Is 
>> anyone out there using FreeBSD for something of this size? I am hoping that 
>> everything
>
> Take a good look at postgres.  In the end, it really depends on your workload 
> and how much truly relational qork you're expecting the DB to do.  If all 
> you're using the DB for is a file store, you might as well use mysql, but 
> then you have to worry about all of your data integrity in your application. 
> Personally, I prefer to put that burden on the DB engine.
>
> The size of your DB is not all that large.  There are people running terabyte 
> DB's under postgres.  Our big DB is around 60Gb with hundreds of millions of 
> rows spread across dozens of tables which are regularly joined with each 
> other for reports.  It is pounded on 24x7 with lots and lots of inserts, 
> updates, and selects going on all the time.
>

Could you share with us your servers' hardware specifics and configuration 
(tuning) of PostgreSQL?
This would help many in making decision.

-----
With best regards,          |            The Power to Serve
Nguyen Tam Chinh            |          http://www.FreeBSD.org
Loc: sp.cs.msu.su           |