Unix Technical Forum

Lower Random Access Time vs RAID 0 / 1

This is a discussion on Lower Random Access Time vs RAID 0 / 1 within the Pgsql Performance forums, part of the PostgreSQL category; --> Hello I plan to buy a new development server and I wonder what will be the best HD combination. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 10:25 AM
Michael Ben-Nes
 
Posts: n/a
Default Lower Random Access Time vs RAID 0 / 1

Hello

I plan to buy a new development server and I wonder what will be the best HD
combination.

I'm aware that "best combination" also relay on DB structure and usage.
so lets assume, heavy duty large DB with mostly reads and heavy write
actions from time to time ( updates / huge transactions ).

Here are the options:

One very fast 10K RPM SATA Western Digital Raptor 150GB HD.
Pro: very low access time and generally 30% faster regarding mainstream
HD.
Con: Expensive.

2 mainstream 7.2K RPM SATA HD in RAID 0.
Pro: fast transfer rate.
Con: Access time is lowered as both HD has to sync for read / write ( true
? ).

2 mainstream 7.2K RPM SATA HD in RAID 1.
Pro: can access parallely different files in the same time ( true ? ).
Con: Slower at writing.

Random access benchmark:
http://www23.tomshardware.com/storag...675&chart =32


Will be happy to hear recommendations and ideas.

Thanks,
Miki

--
--------------------------------------------------
Michael Ben-Nes - Internet Consultant and Director.
http://www.epoch.co.il - weaving the Net.
Cellular: 054-4848113
--------------------------------------------------

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:08 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com