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

From Jim C. Nasby
Subject Re: [PATCHES] O_DIRECT for WAL writes
Date
Msg-id 20050623171601.GB89438@decibel.org
Whole thread Raw
In response to Re: [PATCHES] O_DIRECT for WAL writes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] O_DIRECT for WAL writes
List pgsql-hackers
On Wed, Jun 22, 2005 at 03:50:04PM -0400, Tom Lane wrote:
> The reason I question "automatic" is that you really want to test each
> drive being used, if the system has more than one; but Postgres has no
> idea what the actual hardware layout is, and so no good way to know what
> needs to be tested.

Would testing in the WAL directory be sufficient? Or at least better
than nothing? Of course we could test in the database directories as
well, but you never know if stuff's been symlinked elsewhere... err, we
can test for that, no?

In any case, it seems like it'd be good to try to test and throw a
warning if the drive appears to be caching or if we think the test might
not cover everything (ie symlinks in the data directory).
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pl/pgsql: END verbosity
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] plpgsql constraint checked data fails to restore