Re: Transactions - Mailing list pgsql-novice

From Mike Castle
Subject Re: Transactions
Date
Msg-id 20001205120554.E17698@thune.mrc-home.org
Whole thread Raw
In response to Re: Transactions  (Helge Bahmann <bahmann@math.tu-freiberg.de>)
List pgsql-novice
On Tue, Dec 05, 2000 at 06:15:28PM +0100, Helge Bahmann wrote:
> yes, if fsync completes, the data is on disk; but if you hard-reset the
> system (as indicated in the original mail) while fsync is in progress you
> will likely end up with a garbled filesystem

And a journalling fs is not necessarily going to help you with that case
due to hardware issues.  Harddrives, especially on commodity level equipment
like PC's, have been known to write garbage as power fluctuates during a
write in this kind of scenario.  So you may well journal garbage as well.
Not necessarily a big improvement.

mrc
--
       Mike Castle       Life is like a clock:  You can work constantly
  dalgoda@ix.netcom.com  and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day.  -- mrc
    We are all of us living in the shadow of Manhattan.  -- Watchmen

pgsql-novice by date:

Previous
From: "Romina N. Tulisi"
Date:
Subject: inner join
Next
From: Tom Lane
Date:
Subject: Re: inner join