Skip to main content

WALWrite

Short Description

Waiting for a write to a WAL file.

Additional Information

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.

How to reduce this wait

  • 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.

PostgreSQL documentation - Write-Ahead Logging (WAL)

Locking in PostgreSQL

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.