Re: Transactions

Поиск
Список
Период
Сортировка
От Mike Castle
Тема Re: Transactions
Дата
Msg-id 20001205120554.E17698@thune.mrc-home.org
обсуждение исходный текст
Ответ на Re: Transactions  (Helge Bahmann <bahmann@math.tu-freiberg.de>)
Список 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 по дате отправления:

Предыдущее
От: "Romina N. Tulisi"
Дата:
Сообщение: inner join
Следующее
От: Tom Lane
Дата:
Сообщение: Re: inner join