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

From Nicholson, Brad (Toronto, ON, CA)
Subject Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
Date
Msg-id 2626AEE4839D064CB0472A3814DC403F46D407DD24@GVW1092EXB.americas.hpqcorp.net
Whole thread Raw
In response to Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1  (Laurent Laborde <kerdezixe@gmail.com>)
Responses Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Laurent Laborde
> Sent: Tuesday, April 19, 2011 8:37 AM
> To: pgsql-performance@postgresql.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.

Brad.


pgsql-performance by date:

Previous
From: Laurent Laborde
Date:
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
Next
From: Laurent Laborde
Date:
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1