Re: fsync vs open_sync

pgsql(at)mohawksoft(dot)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