From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: "fsync = off" in recovery
Date: Wed, 7 Apr 2021 22:21:55 +0700
Message-ID: <YG3OEx8aSe2JU175@admin.sibptus.ru> (raw)
Dear Colleagues,
When a cluster is in recovery mode (a delayed replica, PITR etc), does
the setting of "fsync = off" speed up the application of WALs?
I've done some experimenting and got dubious results, so what does the
theory say?
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
Attachments:
signature.asc (application/pgp-signature, 454B) download
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: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: "fsync = off" in recovery
In-Reply-To: <YG3OEx8aSe2JU175@admin.sibptus.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox