Postgres Pro
Downloads
Home   >   mailing lists

"fsync = off" in recovery - Mailing list pgsql-admin

From Victor Sudakov
Subject "fsync = off" in recovery
Date
Msg-id YG3OEx8aSe2JU175@admin.sibptus.ru
Whole thread Raw
Responses Re: "fsync = off" in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Jayson Hreczuck
Date:
Subject: Re: PG_CRON in AWS RDS PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: "fsync = off" in recovery