Re: Simplifying wal_sync_method - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Simplifying wal_sync_method
Date
Msg-id 20050809140438.GA19070@alvh.no-ip.org
Whole thread Raw
In response to Re: Simplifying wal_sync_method  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-hackers
On Tue, Aug 09, 2005 at 12:58:31PM +0200, Magnus Hagander wrote:

> > Now thinking about it, the guy had corrupt table, not WAL log.
> > How is WAL->tables synched?  Does the 'wal_sync_method' 
> > affect it or not?
> 
> I *think* it always fsyncs() there as it is now, but I'm not 100% sure.

No.  If fsync is off, then no fsync is done to the data files on
checkpoint either.  (See mdsync() on src/backend/storage/smgr/md.c)

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)


pgsql-hackers by date:

Previous
From: Jake Stride
Date:
Subject: Re: MySQL to PostgreSQL for SugarCRM
Next
From: "Magnus Hagander"
Date:
Subject: Re: Simplifying wal_sync_method