Re: Intel 320 SSD info - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Intel 320 SSD info
Date
Msg-id CAHyXU0zzGoVDnxLkJx7fVrmwOeb4b8L+D+t1-RC8dFTWeEK7TA@mail.gmail.com
Whole thread Raw
In response to Re: Intel 320 SSD info  (Andy <angelflow@yahoo.com>)
List pgsql-performance
On Wed, Aug 24, 2011 at 12:23 PM, Andy <angelflow@yahoo.com> wrote:
> According to the specs for database storage:
> "Random 4KB arites: Up to 600 IOPS"
> Is that for real? 600 IOPS is *atrociously terrible* for an SSD. Not much
> faster than mechanical disks.
> Has anyone done any performance benchmark of 320 used as a DB storage? Is it
> really that slow?

I have one experience with 320 SSD that replaced a 4 drive RAID 10 10k
raid.  The site users and administrator in question gave summarized
the before/after experience thusly: "PFM" (Pure Magic).  Workload-wise
it was a largish database (200gb+), 50% read, 50% write, mixed
olap/oltp.

merlin

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: How to track number of connections and hosts to Postgres cluster
Next
From:
Date:
Subject: Re: Reports from SSD purgatory