Re: Postgres, fsync, and OSs (specifically linux)

Thomas Munro <thomas.munro@enterprisedb.com>

View thread View on postgr.es

From: Thomas Munro <thomas.munro@enterprisedb.com>

To: Craig Ringer <craig@2ndquadrant.com>

Cc: Asim R P <apraveen@pivotal.io>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2018-10-02T05:50:26Z

Lists: pgsql-hackers

Attachments

0001-Keep-file-descriptors-open-to-avoid-losing-errors-v4.patch (application/octet-stream) patch v4-0001
0002-Add-an-fsync-request-pipe-for-Windows-v4.patch (application/octet-stream) patch v4-0002

On Fri, Sep 28, 2018 at 9:37 PM Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> The other patches in this tarball are all as posted already, but are
> now rebased and assembled in one place.  Also pushed to
> https://github.com/macdice/postgres/tree/fsyncgate .

Here is a new version that fixes an assertion failure during crash
recovery, revealed by cfbot.  I also took the liberty of squashing the
patch stack into one and writing a new commit message, except the
Windows part which seems worth keeping separate until we agree it's
the right way forward.

-- 
Thomas Munro
http://www.enterprisedb.com

Commits

PANIC on fsync() failure.
- 9ccdd7f66e33 12.0 landed
- f1ff5f51d249 9.4.21 landed
- 312435232217 9.5.16 landed
- b9cce9ddfa17 9.6.12 landed
- afbe03f65470 10.7 landed
- 6534d544cd77 11.2 landed
Fix and improve pg_atomic_flag fallback implementation.
- 8c3debbbf618 11.0 cited