Re: Reliability with RAID 10 SSD and Streaming Replication - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Reliability with RAID 10 SSD and Streaming Replication
Date
Msg-id 519D174A.4050703@commandprompt.com
Whole thread Raw
In response to Re: Reliability with RAID 10 SSD and Streaming Replication  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Reliability with RAID 10 SSD and Streaming Replication
List pgsql-performance
On 05/22/2013 11:06 AM, Greg Smith wrote:

> I have some moderately fast SSD based transactional systems that are
> still using traditional drives with battery-backed cache for the
> sequential writes of the WAL volume, where the data volume is on Intel
> 710 disks.  WAL writes really burn through flash cells, too, so keeping
> them on traditional drives can be cost effective in a few ways.  That
> approach is lucky to hit 10K TPS though, so it can't compete against
> what a PCI-E card like the FusionIO drives are capable of.

Greg, can you elaborate on the SSD + Xlog issue? What type of burn
through are we talking about?

JD



--
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
    a rose in the deeps of my heart. - W.B. Yeats


pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Next
From: Greg Smith
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication