Skip to main content

WalWriterMain

Short Description

Waiting in main loop of WAL writer process.

Additional Information​

Write-Ahead Logging (WAL) is a standard method for ensuring data integrity. The WALWritermain wait occurs while PostgreSQL WAL writer waits for work to do.

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.