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 |
_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
