"fsync = off" in recovery

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: "fsync = off" in recovery
Date: 2021-04-07 15:21:55
Message-ID: YG3OEx8aSe2JU175@admin.sibptus.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)fidonet

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2021-04-07 15:35:01 Re: "fsync = off" in recovery
Previous Message Jayson Hreczuck 2021-04-07 11:41:14 Re: PG_CRON in AWS RDS PostgreSQL