fsync = true beneficial on ext3?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: fsync = true beneficial on ext3?
Date: 2004-02-08 18:12:27
Message-ID: 200402081112.27843.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm curious what the consensus is, if any, on use of fsync on ext3
filesystems with postgresql 7.3.4 or later. I did some recent performance
tests demonstrating a 45%-70% performance improvement for simple inserts
with fsync off on one particular system. Does fsync = true buy me any
additional recoverability beyond ext3's journal recovery?

If we write something without sync'ing, presumably it's immediately
journaled? So even if the DB crashes prior to fsync'ing, are we fully
recoverable? I've been running a few pgsql clusters on ext3 with fsync =
false, suffered numerous OS crashes, and have yet to lose any data or see
any corruption from any of those crashes. Have I just been lucky?

TIA.

Ed

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2004-02-08 18:13:47 Re: Fwd: Favorite DB poll on ORA
Previous Message Martijn van Oosterhout 2004-02-08 17:59:18 Re: piping output to file