full_page_writes
A parameter determining whether the entire content of each disk page to is written to WAL after a checkpoint
full_page_writes
is a configuration parameter determining whether the entire content of each disk page to is written to WAL during the first modification of that page after a checkpoint.
full_page_writes
was added in PostgreSQL 8.1.
IMPORTANT: turning off this setting risks irreparable damage to the database.
Default value
The default value for full_page_writes
is: on
.
Change history
- PostgreSQL 8.1
- added (commit 326a7a07)
References
- PostgreSQL documentation: full_page_writes