Skip site navigation (1) Skip section navigation (2)

Re: Hardware suggestions for Linux/PGSQL server

From: Jeff Bohmer <bohmer(at)visionlink(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware suggestions for Linux/PGSQL server
Date: 2003-12-15 16:37:29
Message-ID: p04330106bc02f8683471@[192.168.1.201] (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-performance
>In the last exciting episode, drew(at)xyzzy(dot)dhs(dot)org ("Andrew G. Hammond") wrote:
>>  I don't know what your budget is, but there are now 10k RPM SATA 150
>>  drives on the market. Their price/performance is impressive. You may
>>  want to consider going with a bunch of these instead of SCSI disks
>>  (more spindles vs. faster spindles). 3ware makes a hardware raid
>>  card that can drive up to 12 SATA disks. I have been told by a few
>>  people who have used it that the linux driver is very solid.
>
>We got a couple of those in for testing purposes; when opportunity
>presents itself, I'll have to check to see if they are any more honest
>about commits than traditional IDE drives.
>
>If they still "lie" the same way IDE drives do, it is entirely
>possible that they are NOT nearly as impressive as you presently
>imagine.  It's not much good if they're "way fast" if you can't trust
>them to actually store data when they claim it is stored...

We lost data because of this very problem when a UPS didn't signal 
the shut down before it ran out of juice.

Here's an excellent explanation of the problem:
http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php

This post indicates that SATA drives still have problems, but a new 
ATA standard might fix things in the future:
http://archives.postgresql.org/pgsql-general/2003-10/msg01395.php

SATA RAID is a good option for a testing server, though.


- Jeff
-- 

Jeff Bohmer
VisionLink, Inc.
_________________________________
303.402.0170
www.visionlink.org
_________________________________
People. Tools. Change. Community.

In response to

pgsql-performance by date

Next:From: Rhaoni Chiu PereiraDate: 2003-12-15 17:01:15
Subject: Unsubscribe
Previous:From: Christopher BrowneDate: 2003-12-15 05:14:29
Subject: Re: Hardware suggestions for Linux/PGSQL server

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group