Re: fsync = true beneficial on ext3? - Mailing list pgsql-general

From Greg Stark
Subject Re: fsync = true beneficial on ext3?
Date
Msg-id 87smdzwo93.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: fsync = true beneficial on ext3?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> JM wrote:
> > Would a battery backed Card do the trick?
>
> No because the fsync causes the data to hit the card.  Without the
> fscync, the data could remain only in the kernel cache.

A battery backed card for the transaction logs wouldn't make it safe to run
without fsync, but it would make the fsyncs basically free.

--
greg

pgsql-general by date:

Previous
From: David Teran
Date:
Subject: Re: RTRIM always used with JDBC?
Next
From: Nikola Milutinovic
Date:
Subject: Re: PgSQL 7.4.2 - NaN on Tru64 UNIX