full_page_writes
No restart — takes effect on reloadtuned by pgconfiguratorboolean (on/off)
Writes a full copy of a page to WAL on its first change after a checkpoint, guarding against torn pages.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
After each checkpoint, the first modification of a page writes the entire page image to WAL. This protects against 'torn pages' — partial writes during a crash, where the OS wrote only some of an 8 kB page. It's what makes crash recovery safe on most storage.
How to tune it
Leave it on. It increases WAL volume (which wal_compression helps with), but turning it off risks unrecoverable corruption unless your storage guarantees atomic 8 kB writes. Like fsync, only consider off on a disposable cluster.