Re[2]: [HACKERS] Remove fsync ON/OFF as a visible option? - Mailing list pgsql-hackers

From Миша Тюрин
Subject Re[2]: [HACKERS] Remove fsync ON/OFF as a visible option?
Date
Msg-id 1426970974.775954998@f255.i.mail.ru
Whole thread Raw
In response to Re: Remove fsync ON/OFF as a visible option?  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-hackers


why does we take so many attention to fsync issue?

but there are also table spaces in tmpfs, wal in tmpfs, disks with cache without bbu, writeback writes and fs without ordering and journal, any CLOUDS, etc etc... in our real world installations.

more over not all of these issues are usually in dba's medium, and what dba really have to do -- is to accept ugly bottom storage properties and DO properly PITR/standby.

and if we have PITR then "fsync or not fsync" in master host doesn't matter so much. and could matter providing fsync in archive host. but doing fsync in archive -- it is workaround for archive_command realization.

in conclusion -- imho, full-page writes is more sensual than fsync when we guarantee PITR.
-- misha

pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Remove fsync ON/OFF as a visible option?
Next
From: Josh Berkus
Date:
Subject: Re: Remove fsync ON/OFF as a visible option?