Re: Do I have a hardware or a software problem?

Niels Kristian Schjødt <nielskristian@xxxxxxxxxxxxx> · Wed, 12 Dec 2012 17:22:10 +0100

Well, In fact I do (as you can see from my configuration). I have a similar server running with hot standby replication - and it runs two 3T HDD in a RAID1 array.
So - is it still very bad if I choose to put four intel 520 disks in a RAID10 array on the other production server?

Den 12/12/2012 kl. 03.47 skrev Craig Ringer <craig@xxxxxxxxxxxxxxx>:

    On 12/12/2012 10:13 AM, Evgeny Shishkin
      wrote:

        Yes, i am aware of this issue. Never experienced this neither on
        intel 520, no ocz vertex 3.

    I wouldn't trust either of those drives. The 520 doesn't have
    Intel's "

    Enhanced Power Loss Data Protection"; it's going to lose its buffers
    if it loses power. Similarly, the Vertex 3 doesn't have any kind of
    power protection. See:

    http://www.intel.com/content/www/us/en/solid-state-drives/ssd-320-series-power-loss-data-protection-brief.html

    http://ark.intel.com/products/family/56572/Intel-SSD-500-Family

    http://www.ocztechnology.com/res/manuals/OCZ_SSD_Breakdown_Q2-11_1.pdf

    The only way I'd use those for a production server was if I had
    synchronous replication running to another machine with trustworthy,
    durable storage - and if I didn't mind some downtime to restore the
    corrupt DB from the replica after power loss.

    -- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services