Re[2]: [HACKERS] Remove fsync ON/OFF as a visible option?

From: Миша Тюрин <tmihail(at)bk(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re[2]: [HACKERS] Remove fsync ON/OFF as a visible option?
Date: 2015-03-21 20:49:34
Message-ID: 1426970974.775954998@f255.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2015-03-21 20:53:47 Re: Remove fsync ON/OFF as a visible option?
Previous Message Jaime Casanova 2015-03-21 20:31:19 Re: Remove fsync ON/OFF as a visible option?