Search Postgresql Archives

Re: Server choice for small workload : raptors or SSD?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 21, 2012 at 6:47 PM, Rory Campbell-Lange
<rory@xxxxxxxxxxxxxxxxxx> wrote:
> I'd be grateful for comments on whether to go with a server with the A
> or B spec. Both servers have the following in common:
>
>    E5620 Quad-Core / 4x 2.40GHz
>    LSI MegaRAID SAS 9260-4i with BBU (6Gbps)
>    48 GB PC3-10600 DDR3 / 1333MHz / registered ECC RAM
>
> Server A:
>
>    4 * 300GB 10K WD raptors in a RAID10 configuration
>
> Server B:
>
>    2 * 500GB 7.2K SATA disks in RAID 1
>    2 * 100GB Intel 710 Solid State SATA 270MBs read, 170MBs write
>        in RAID 1 **

I just purchased up a big DB server... I went with the Intel 320 SSDs
because they were cheaper, and I needed 8 of them.  I also splurged
for the 9265 LSI card, and added the FastPath option for speeding up
the SSDs.  This will probably add a bit over $150 to your SSD server.
 I have some servers now using 320s as boot drives, and they are
*wicked* fast.

All that aside, if your DB is 40GB now, it doesn't matter so much what
your disks are since you're going to end up running primarily out of
server disk cache.

Is your workload heavily read or heavily write?  If you are not
writing so much, then your RAM is going to make the difference in
these drives pretty insignificant.

And personally, I avoid WD drives like the plague.  Nothing but bad
experience in my large disk arrays.  I prefer Hitachi or Seagate.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux