Provide an explanation About Write Ahead Logging?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

WAL or write-ahead logging is a standard method to ensure data integrity. It is a protocol or the correct rule to write both actions and changes into a transaction log. This feature is known to increase the reliability of the database by logging changes before any changes or updating to the database. This provides the log of the database in case of a database crash. This helps to start the work from the point it was discontinued.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Postgresql Interview Questions

    List some of the features of Postgresql ?

     Following are some of the features of Postgresql : Object-relational database Support and Extensibility for SQL fle..

    Postgresql Interview Questions

    What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

     The SQL standard is defined by four levels of transaction isolation basically regarding three phenomena. The three phe..

    Postgresql Interview Questions

    Put some light on Multi-Version concurrency control?

     MVCC or better known as Multi-version concurrency control is used to avoid unwanted locking of the database. The time ..