public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Thomas Munro <[email protected]>
Cc: vignesh C <[email protected]>
Cc: Peter Smith <[email protected]>
Cc: pgsql-hackers <[email protected]>
Subject: Re: Volatile write caches on macOS and Windows, redux
Date: Fri, 24 May 2024 23:41:18 -0500
Message-ID: <ZlFr7pH1ZvDgO3uw@nathan> (raw)
In-Reply-To: <CA+hUKG+gz7ktX4Hu1Qi9R_ac_jpwb0B=281ccT7MvbOkHD9kJg@mail.gmail.com>
References: <CA+hUKG+F0EL4Up6yVYbbcWse4xKaqW4wc2xpw67Pq9FjmByWVg@mail.gmail.com>
<CAHut+PtyKB-GMy8NuPe6rZn8v33TJKW1fvezACG1ia9z0+6qtg@mail.gmail.com>
<CALDaNm0YijywGoFDXsbM4UyPq_zjxoeTAHGMfvKpmZdx4+khjQ@mail.gmail.com>
<CA+hUKGKWPupEYNGDEyYcwrtPn8FmqJ0aThOxVuGz44qphhOyLg@mail.gmail.com>
<CA+hUKG+gz7ktX4Hu1Qi9R_ac_jpwb0B=281ccT7MvbOkHD9kJg@mail.gmail.com>
On Thu, Mar 14, 2024 at 01:12:05PM +1300, Thomas Munro wrote:
> Short sales pitch for these patches:
>
> * the default settings eat data on Macs and Windows
> * nobody understands what wal_sync_method=fsync_writethrough means anyway
> * it's a weird kludge that it affects not only WAL, let's clean that up
I recently started using macOS for hacking on Postgres and noticed this
problem, so I was delighted to find this thread. I intend to review
further soon, but +1 for improving the default settings. I think we might
also need some additional fcntl(F_FULLFSYNC) calls in sync_pgdata(),
sync_dir_recurse(), etc., which are used by initdb, pg_basebackup, and
more.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Volatile write caches on macOS and Windows, redux
In-Reply-To: <ZlFr7pH1ZvDgO3uw@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox