From: Scott Marlowe <scott.marlowe@gmail.com>
To: Pierre C <lists@peufeu.com>
Cc: James Mansion <james@mansionfamily.plus.com>
Cc: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Yeb Havinga <yebhavinga@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: mysql to postgresql, performance questions
Date: Thu, 25 Mar 2010 14:38:07 -0600
Message-ID: <dcc563d11003251338m1369b4efh2efa600c9c8fe7dd@mail.gmail.com> (raw)
In-Reply-To: <op.u944juqoeorkce@localhost>
References: <4BA23936.2030507@gmail.com>
<4BA596D2.4050406@squeakycode.net>
<20100323185232.GD6662@rice.edu>
<5342.1269372121@sss.pgh.pa.us>
<4BA934B9.9070401@2ndquadrant.com>
<4BA9D39B.6020103@gmail.com>
<1269421198.11473.50.camel@hvost>
<4BABC1E0.7010607@mansionfamily.plus.com>
<op.u944juqoeorkce@localhost>
On Thu, Mar 25, 2010 at 2:29 PM, Pierre C <lists@peufeu.com> wrote:
>> Hannu Krosing wrote:
>>>
>>> Pulling the plug should not corrupt a postgreSQL database, unless it was
>>> using disks which lie about write caching.
>>>
>> Didn't we recently put the old wife's 'the disks lied' tale to bed in
>> favour of actually admiting that some well known filesystems and saftware
>> raid systems have had trouble with their write barriers?
>
> I put a cheap UPS on the home server (which uses Software RAID) precisely
> because I don't really trust that stuff, and there is also the RAID5 write
> hole... and maybe the RAID1 write hole too... and installing a UPS takes
> less time that actually figuring out if the system is power-loss-safe.
Very true, a UPS might not cover every possible failure mode, but it
sure takes care of an aweful lot of the common ones.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, lists@peufeu.com, james@mansionfamily.plus.com, hannu@2ndquadrant.com, yebhavinga@gmail.com, greg@2ndquadrant.com, tgl@sss.pgh.pa.us, reedstrm@rice.edu
Subject: Re: mysql to postgresql, performance questions
In-Reply-To: <dcc563d11003251338m1369b4efh2efa600c9c8fe7dd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox