Filesystem Direct I/O and WAL sync option - Mailing list pgsql-performance

From Dimitri
Subject Filesystem Direct I/O and WAL sync option
Date
Msg-id 5482c80a0707030754o740c82b6s4598dc668720d014@mail.gmail.com
Whole thread Raw
Responses Re: Filesystem Direct I/O and WAL sync option
List pgsql-performance
All,

I'm very curious to know if we may expect or guarantee any data
consistency with WAL sync=OFF but using file system mounted in Direct
I/O mode (means every write() system call called by PG really writes
to disk before return)...

So may we expect data consistency:
   - none?
   - per checkpoint basis?
   - full?...

Thanks a lot for any info!

Rgds,
-Dimitri

pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Delete Cascade FK speed issue
Next
From: Heikki Linnakangas
Date:
Subject: Re: Filesystem Direct I/O and WAL sync option