Re: win32 performance - fsync question

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: win32 performance - fsync question
Дата
Msg-id 4214B68C.8000901@dunslane.net
обсуждение исходный текст
Ответ на Re: win32 performance - fsync question  ("E.Rodichev" <er@sai.msu.su>)
Ответы Re: win32 performance - fsync question  (lsunley@mb.sympatico.ca)
Re: win32 performance - fsync question  (Evgeny Rodichev <er@sai.msu.su>)
Список pgsql-hackers

E.Rodichev wrote:

>
> This problem is addressed by file system (fsck, journalling etc.).
> Is it reasonable to handle it directly within application?
>
>

In the words of the Duke of Wellington, "If you believe that you'll 
believe anything."

Please review past discussions on the mailing lists on this point.

BTW, most journalling file systems do not guarantee file integrity, only 
file metadata integrity. In particular, I believe this is tru of NTFS 
(and whether it even does that has been debated).

So by all means turn off fsync if you want the performance gain *and* 
you accept the risk. But if you do, don't come crying later that your 
data has been lost or corrupted.

(the results are interesting, though - with fsync off Windows and Linux 
are in the same performance ballpark.)

cheers

andrew


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: win32 performance - fsync question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Terminating a SETOF function call sequence