pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Jeff Bohmer <bohmer@visionlink.org>
To: pgsql-performance@postgresql.org
Subject: Re: Hardware suggestions for Linux/PGSQL server
Date: Mon, 15 Dec 2003 09:37:29 -0700
Message-ID: <p04330106bc02f8683471@[192.168.1.201]> (raw)
In-Reply-To: <m38yle7jd6.fsf@wolfe.cbbrowne.com>
References: <Pine.LNX.4.33.0312111548100.16283-100000@css120.ihs.com>
<p04330103bc0148b6ebfe@[192.168.1.201]>
<3FDD35CF.6080103@xyzzy.dhs.org>
<m38yle7jd6.fsf@wolfe.cbbrowne.com>
>In the last exciting episode, drew@xyzzy.dhs.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.
view thread (12+ messages)
Message-ID: <p04330106bc02f8683471@[192.168.1.201]> Permalink: ../p04330106bc02f8683471@%5B192.168.1.201%5D/ Also on: postgresql.org/message-id/p04330106bc02f8683471@[192.168.1.201] ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-performance@postgresql.org Cc: bohmer@visionlink.org Subject: Re: Hardware suggestions for Linux/PGSQL server In-Reply-To: <p04330106bc02f8683471@[192.168.1.201]> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox