Re: [PERFORM] fsync method checking - Mailing list pgsql-hackers

From markw@osdl.org
Subject Re: [PERFORM] fsync method checking
Date
Msg-id 200403261701.i2QH0x203524@mail.osdl.org
Whole thread Raw
List pgsql-hackers
On 26 Mar, Bruce Momjian wrote:
> markw@osdl.org wrote:
>> On 26 Mar, Manfred Spraul wrote:
>> > markw@osdl.org wrote:
>> >
>> >>Compare file sync methods with one 8k write:
>> >>        (o_dsync unavailable)
>> >>        open o_sync, write       6.270724
>> >>        write, fdatasync        13.275225
>> >>        write, fsync,           13.359847
>> >>
>> >>
>> > Odd. Which filesystem, which kernel? It seems fdatasync is broken and
>> > syncs the inode, too.
>>
>> It's linux-2.6.5-rc1 with ext2 filesystems.
>
> Would you benchmark open_sync for wal_sync_method too?

Oh yeah.  Will try to get results later today.

Mark


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Per database users/admins, handy for database virtual hosting...
Next
From: Bruce Momjian
Date:
Subject: Re: Nested transaction proposal - take N (N > 2)