Re: Postgres and fsync - Mailing list pgsql-general

From Andres Freund
Subject Re: Postgres and fsync
Date
Msg-id 20180423000530.u3wbek72qv6jhben@alap3.anarazel.de
Whole thread Raw
In response to Postgres and fsync  (Tim Cross <theophilusx@gmail.com>)
Responses Re: Postgres and fsync  (Tim Cross <theophilusx@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Postgres and fsync
Next
From: Alexander Farber
Date:
Subject: Adding AVG to a JOIN