Kenji M <[EMAIL PROTECTED]> wrote: > Hello everyone, first time list leech. > > I am in the process of speccing out a high end PC to be used > as a database server for PostgreSQL. We are currently running > MySQL on Linux, but want to migrate our code to PostgreSQL and > we are primarily a FreeBSD shop. > > I am currently specing a 2U dual Xeon server and hope to use > RAID 0+1 capability. The question is for PostgreSQL admins... > > 1) Which RAID controller should we use?
Depends on your need. If you don't have outrageous requirements, vinum would work fine as software raid. If you have very high performance requirements, the general consensus on the Postgres lists is that a SCSI raid controller with a large battery-backed cache produces the best performing, most reliable systems. I don't have any specific model numbers, though. > 2) Considering Q1, does it not even make sense to use FreeBSD+PostgreSQL > and bite the bullet and go with Linux (assuming it has better hw RAID > support) and run PostgreSQL on that using a fancier journaling filesystem. I doubt it. If you use battery-backed cache, you have no need of journalling. Even still, you get comparible performance with ufs+softupdates (although it's just a _little_ slower). Now, I've never done "plug tests" on UFS, but I haven't heard of any UFS filesystems getting beyond the point that PostgreSQL couldn't recover the database. -- Bill Moran Potential Technologies http://www.potentialtech.com _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"