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

Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1

From: Laurent Laborde <kerdezixe(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
Date: 2011-04-19 13:44:09
Message-ID: BANLkTikMR262fq-J7RG9quj3DO8zLOxZrw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Apr 19, 2011 at 3:21 PM, Nicholson, Brad (Toronto, ON, CA)
<bnicholson(at)hp(dot)com> wrote:
>> -----Original Message-----
>> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-
>> owner(at)postgresql(dot)org] On Behalf Of Laurent Laborde
>> Sent: Tuesday, April 19, 2011 8:37 AM
>> To: pgsql-performance(at)postgresql(dot)org
>> Subject: Re: [PERFORM] postgresql random io test with 2 SSD Kingston
>> V+100 500GB in (software) Raid1
>>
>> If we use them (unlikely), recovery in case of power outage isn't a
>> problem, as we will use it on slave database (using Slony-I) that can
>> be created/destroyed at will.
>> And, anyway, our slave have fsync=off so the battery won't change
>> anything in case of power outage :)
>
> Are these on the same UPS?  If so, you have a failure case that could cause you to lose everything.

Oh, not at all.
We're doing balancing/switch/failover between 2 different datacenter.
We can maintain (somewhat degraded) operation if one of the datacenter fail :)

-- 
Laurent "ker2x" Laborde
Sysadmin & DBA at http://www.over-blog.com/

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2011-04-19 14:22:55
Subject: Re: Shouldn't we have a way to avoid "risky" plans?
Previous:From: Nicholson, Brad (Toronto, ON, CA)Date: 2011-04-19 13:21:04
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1

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