Re: Postgres and fsync

Поиск
Список
Период
Сортировка
От Tim Cross
Тема Re: Postgres and fsync
Дата
Msg-id 87sh7lpoj3.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: Postgres and fsync  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
Andres Freund <andres@anarazel.de> writes:

> Hi,
>
> On 2018-04-23 08:30:25 +1000, Tim Cross wrote:
>> the recent article in LWN regarding issues with fsync and error
>> reporting in the Linux kernel and the potential for lost data has
>> prompted me to ask 2 questions.
>
> Note that you need to have *storage* failures for this to
> happen. I.e. your disk needs to die, and there's no raid or such to fix
> the issue.
>
>
>> 1. Is this issue low level enough that it affects all potentially
>> supported sync methods on Linux? For example, if you were concerned
>> about this issue and you had a filesystem which supports open_sync or
>> open_datasync etc, is switching to one of these options something which
>> should be considered or is this issue low level enough that all sync
>> methods are impacted?
>
> No, the issue is largely about datafiles whereas the setting you refer
> to is about the WAL.
>
> Greetings,
>
> Andres Freund

OK, thanks.

-- 
Tim Cross


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Adding AVG to a JOIN
Следующее
От: Dale Seaburg
Дата:
Сообщение: Re: Strange error in Windows 10 Pro