Re: fsync vs open_sync - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: fsync vs open_sync
Date
Msg-id 17872.24.91.171.78.1092107131.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: fsync vs open_sync  (Mark Kirkwood <markir@coretech.co.nz>)
Responses Re: fsync vs open_sync  (Doug McNaught <doug@mcnaught.org>)
Re: fsync vs open_sync  (Manfred Spraul <manfred@colorfullife.com>)
List pgsql-hackers
> Just out of interest, what happens to the difference if you use *ext3*
> (perhaps with data=writeback)

Actually, I was working for a client, so it wasn't a general exploritory,
but I can say that early on we discovered that ext3 was about the worst
file system for PostgreSQL. We gave up on it and decided to use ext2.

I have been considering a full sweep in my test lab off client time later on.

ext2, ext3, jfs, xfs, and ReiserFS, fsync on with fdatasync or open_sync,
and fsync off.

One million inserts with auto commit.





pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Tablespace issues (comment on ,moving indexes)
Next
From: Doug McNaught
Date:
Subject: Re: fsync vs open_sync