Postgres Pro
Downloads
Home   >   mailing lists

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

From Jonah H. Harris
Subject Re: Filesystem Direct I/O and WAL sync option
Date
Msg-id 36e682920707091346w49824ac6x65c8adddbaa0ef7@mail.gmail.com
Whole thread Raw
In response to Re: Filesystem Direct I/O and WAL sync option  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Filesystem Direct I/O and WAL sync option
List pgsql-performance
Tree view 
On 7/9/07, Jim C. Nasby <decibel@decibel.org> wrote:
> BTW, it might be worth trying the different wal_sync_methods. IIRC,
> Jonah's seen some good results from open_datasync.

On Linux, using ext3, reiser, or jfs, I've seen open_sync perform
quite better than fsync/fdatasync in most of my tests.  But, I haven't
done significant testing with direct I/O lately.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Filesystem Direct I/O and WAL sync option
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PostgreSQL publishes first real benchmark