Re: Recomended FS - Mailing list pgsql-general

From Greg Stark
Subject Re: Recomended FS
Date
Msg-id 87ismay6x1.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Recomended FS  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Recomended FS
List pgsql-general
"scott.marlowe" <scott.marlowe@ihs.com> writes:

> Sweet.  It may be that the promise is turning off the cache, or that the
> new generation of IDE drives is finally reporting fsync correctly.  Was
> there a performance difference in the set with write cache on or off?

Check out this thread. It seems the ATA standard does not include any way to
make fsync work properly without destroying performance. At least on linux
even that much is impossible without disabling caching entirely as the
operation required isn't exposed to user-space. There is some hope for the
future though.

http://www.ussg.iu.edu/hypermail/linux/kernel/0310.2/0163.html

> > The other interesting possibility is that Freebsd with soft updates
> > helped things remain salvageable in the cache enabled case (as some
> > writes *must* be lost at power off in this case)....
>
> Free BSD may be the reason here.  If it's softupdates are ordered in the
> right way, it may be that even with write caching on, the drives "do the
> right thing" under BSD.  Time to get out my 5.0 disks and start playing
> with my test server.  Thanks for the test!

I thought soft updates applied only to directory metadata changes.

--
greg

pgsql-general by date:

Previous
From: Grant Rutherford
Date:
Subject: PostgreSQL with MS Query?
Next
From: Tom Lane
Date:
Subject: Re: Timestamp and interval precision