Re: [PATCHES] O_DIRECT for WAL writes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] O_DIRECT for WAL writes
Date
Msg-id 794.1119501215@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] O_DIRECT for WAL writes  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: [PATCHES] O_DIRECT for WAL writes
Re: [PATCHES] O_DIRECT for WAL writes
Re: [PATCHES] O_DIRECT for WAL writes
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
>> Curt Sampson <cjs@cynic.net> writes:
>>> But is it really a problem? I somewhere got the impression that some
>>> drives, on power failure, will be able to keep going for long enough to
>>> write out the cache and park the heads anyway. If so, the drive is still
>>> guaranteeing the write.

> I've seen discussion about disks behaving this way. There's no magic:
> they're battery backed.

Oh, sure, then it's easy ;-)

The bottom line here seems to be the same as always: you can't run an
industrial strength database on piece-of-junk consumer grade hardware.
Our problem is that because the software is free, people expect to run
it on bottom-of-the-line Joe Bob's Bait And PC Shack hardware, and then
they blame us when they don't get the same results as the guy running
Oracle on million-dollar triply-redundant server hardware.  Oh well.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Maxwell
Date:
Subject: Re: [PATCHES] O_DIRECT for WAL writes
Next
From: Tom Lane
Date:
Subject: Re: HaveNFreeProcs ?