Re: Transactions

From: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transactions
Date: 2000-12-05 18:05:54
Message-ID: 20001205120554.E17698@thune.mrc-home.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ix(dot)netcom(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-12-05 20:21:02 Re: inner join
Previous Message Mike Castle 2000-12-05 17:54:46 running totals