What can you tell about WAL (Write Ahead Logging)?

1.	What can you tell about WAL (Write Ahead Logging)?
Answer» Write Ahead Logging is a feature that increases the database reliability by logging changes before any changes are DONE to the database. This ensures that we have ENOUGH INFORMATION when a database crash OCCURS by helping to pinpoint to what point the work has been complete and gives a starting point from the point where it was discontinued. For more information, you can REFER here.

Answer»

Write Ahead Logging is a feature that increases the database reliability by logging changes before any changes are DONE to the database. This ensures that we have ENOUGH INFORMATION when a database crash OCCURS by helping to pinpoint to what point the work has been complete and gives a starting point from the point where it was discontinued.

For more information, you can REFER here.

Discussion

No Comment Found

Related InterviewSolutions

Differentiate between commit and checkpoint.
What are parallel queries in PostgreSQL?
Does PostgreSQL support full text search?
How will you take backup of the database in PostgreSQL?
How do you perform case-insensitive searches using regular expressions in PostgreSQL?
What is the main disadvantage of deleting data from an existing table using the DROP TABLE command?
What can you tell about WAL (Write Ahead Logging)?
How do you check the rows affected as part of previous transactions?
What do you understand by command enable-debug?
What do you understand by multi-version concurrency control?

What can you tell about WAL (Write Ahead Logging)?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment