Re: fsync vs open_sync - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: fsync vs open_sync
Date
Msg-id 877js7itfo.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: fsync vs open_sync  (pgsql@mohawksoft.com)
List pgsql-hackers
pgsql@mohawksoft.com writes:

>> 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'd be interested in which ext3 mount options you used--I can see how
anything other than 'data=writeback' could be a performance killer.
I've been meaning to run a few tests myself, but haven't had the
time...

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.  --T. J. Jackson, 1863


pgsql-hackers by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Re: fsync vs open_sync
Next
From: Jan Wieck
Date:
Subject: Re: VACUUM DELAY