Help with new storage System

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Help with new storage System

Postby smoke180 » Mon May 07, 2012 2:23 pm

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
smoke180
 
Posts: 13
Joined: Sat May 24, 2008 5:19 pm

Re: Help with new storage System

Postby kraada » Mon May 07, 2012 2:33 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Help with new storage System

Postby smoke180 » Mon May 07, 2012 3:07 pm

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?
smoke180
 
Posts: 13
Joined: Sat May 24, 2008 5:19 pm

Re: Help with new storage System

Postby kraada » Wed May 09, 2012 9:45 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 28 guests

cron