IO - WALWrite
Waiting for a write to a WAL file.
Write-Ahead Logging (WAL) is a standard method for ensuring data integrity. The WALWrite
wait occurs while PostgreSQL flushes WAL records to disk or during a WAL segment switch.
- Increase the number of
wal_buffers
available to the database. - Ensure that filesystem journaling is turned off for data files and WAL files. Because WAL restores database file contents after a crash, journaled file systems are not necessary for reliable storage of the data files or WAL files. Journaled file systems do improve boot speed after a crash.