Filesystem Direct I/O and WAL sync option

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Filesystem Direct I/O and WAL sync option
Date: 2007-07-03 14:54:38
Message-ID: 5482c80a0707030754o740c82b6s4598dc668720d014@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-07-03 15:06:29 Re: Filesystem Direct I/O and WAL sync option
Previous Message Michael Fuhr 2007-07-03 11:33:42 Re: Delete Cascade FK speed issue