Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
| От | Laurent Laborde |
|---|---|
| Тема | Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1 |
| Дата | |
| Msg-id | BANLkTikMR262fq-J7RG9quj3DO8zLOxZrw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1 ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>) |
| Список | pgsql-performance |
On Tue, Apr 19, 2011 at 3:21 PM, Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com> wrote: >> -----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. 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/
В списке pgsql-performance по дате отправления: