Re: Running FreeBSD/PostgreSQL on high-end dual Xeon box

2004-06-04 Thread Kenji M
Thanks guys! After doing some additional reading and your comments I think staying with FreeBSD coupled with a good RAID controller would probably be the least hassle, reliable, and good performing setup. I am looking at a dual Xeon box using an Adpatec 2200S RAID controller with the write

Re: Running FreeBSD/PostgreSQL on high-end dual Xeon box

2004-06-04 Thread Chuck Swiger
Kenji M wrote: I had been considering the same setup, but it might make sense just to use 3 disk RAID5 with hot spare ready. The new RAID controller implementation might not buy us much by using 0+1 vs. 5. Any thoughts? I doubt many databases recommend RAID-5; using RAID 0+1 is likely to be a

Running FreeBSD/PostgreSQL on high-end dual Xeon box

2004-06-03 Thread Kenji M
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

Re: Running FreeBSD/PostgreSQL on high-end dual Xeon box

2004-06-03 Thread Bill Moran
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

Re: Running FreeBSD/PostgreSQL on high-end dual Xeon box

2004-06-03 Thread Charles Swiger
On Jun 3, 2004, at 5:42 PM, Kenji M wrote: 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? You haven't mentioned whether you plan to use SCSI or IDE drives. The PERC RAID