Advisor check: fsync is disabled on PostgreSQL configuration¶
Description¶
When this parameter is enabled (which it is by default), the PostgreSQL server tries to make sures that updates are physically written to disk, by issuing fsync() system calls or various equivalent methods mentioned in wal_sync_method.
Turning off fsync can slightly improve performance with the risk of unrecoverable data corruption in case of a power failure or system crash.
Therefore, it is only advisable to turn off fsync if you can easily recreate your entire database from external data. High-quality hardware alone is not a sufficient justification for turning off fsync.
ALTER SYSTEM SET fsync = on;
-
Signal the PostgreSQL server to reload the configuration
SELECT pg_reload_conf(); -
Flush all the pages safely to disk using the initdb utility
$ initdb -D $PGDATA --sync-only syncing data to disk … ok -
Run sync on the filesystem
$ sync
Need more support from Percona?¶
Subscribe to Percona Platform to get database support with guaranteed SLAs or proactive database management services from the Percona team.