data=writeback and safety of WAL files - Mailing list pgsql-general

From Lukasz Biegaj
Subject data=writeback and safety of WAL files
Date
Msg-id 569a2a1d-4613-449e-6fa4-5cc685592d69@unity.pl
Whole thread Raw
List pgsql-general
Hi,

The <https://www.postgresql.org/docs/13/wal-intro.html> document states, 
that in case of ext3 filesystems, filesystem journaling can be 
configured with data=writeback option to increase performance (in 
specific cases).

Per my understanding this causes some of the filesystem integrity 
mechanism to be loosened and in case of PostgreSQL data partition it 
would be okay because WAL files replicate this functionality at a higher 
level.

What about the storage of WAL files itself? Wouldn't it be possible that 
in case of unexpected reboot and dirty file system these files get 
corrupted, making the database state impossible to bring to operational 
level?


-- 
Lukasz Biegaj | Unity Group | https://www.unitygroup.com/
System Architect, AWS Solutions Architect



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Postgres 9.3 service no longer starts on Windows 8.1
Next
From: Kai Daguerre
Date:
Subject: Custom FDW - the results of a nested query/join not being passed as qual to the outer query