Page 1 of 1

Help with new storage System

PostPosted: Mon May 07, 2012 2:23 pm
by smoke180
Hello,

i look for a new storage System for my Poker PC. I like to buy a LSI MegaRAID 9266-8i controller with 4 OCZ Vertex4 256 GB in Raid 10 for PSQL.
My Win 7 run at a OCZ Vertex 3 256 GB.
What you think is better to let PSQL complete on Raid 10 or split it to two Vertex 2 128 GB Raid 1?
Is it better to install PT3 and PT4 at Raid 10 or at the OS Disk?

thank you

Re: Help with new storage System

PostPosted: Mon May 07, 2012 2:33 pm
by kraada
The PT3 installation directory really doesn't matter to any extent like the PostgreSQL installation directory does. Either RAID 1 or RAID10 should work well for our purposes - according to this document RAID10 will give you the best performance in general but I can't say I've gotten any specific feedback from users with that setup to verify.

Re: Help with new storage System

PostPosted: Mon May 07, 2012 3:07 pm
by smoke180
my biggest confuse is when PSQL run at raid 10, did i have any performance improve when i split the log files to two vertex 128GB Raid 1? Or did it slow down because the Raid 10 is so much faster then the Raid 1?
I now that the reason to split log files and Database is because the I/O is higher. But i have at the Raid 10 much more I/O then at Raid 1.
But when the Log files don't need more I/O then the Vertex 3 can give, i think the best choice is to Split.
Anybody that can confirm this?

Re: Help with new storage System

PostPosted: Wed May 09, 2012 9:45 am
by kraada
I've spoken with one of our developers about your setup. He states that the Vertex alone should be enough to make the bottleneck elsewhere on your system even without RAID.

Also, you should consider moving to PT4 - we've made considerable improvements that might make your experience much better there when you're looking for peak performance.