Re: [PATCHES] O_DIRECT for WAL writes

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: [PATCHES] O_DIRECT for WAL writes
Дата
Msg-id 20050623171601.GB89438@decibel.org
обсуждение исходный текст
Ответ на Re: [PATCHES] O_DIRECT for WAL writes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCHES] O_DIRECT for WAL writes  (Douglas McNaught <doug@mcnaught.org>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: pl/pgsql: END verbosity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] plpgsql constraint checked data fails to restore