Does Aurora PostgreSQL use wal buffer?

0

Hi,

I was going through the below reinvent video about Deep dive on Amazon Aurora with PostgreSQL. I see a mention about "Concurrency : Remove Log buffer" and "Aurora PostgreSQL: Writing Less". So does this mean that Aurora Postgres doesn't use wal buffer or is there is there any change in the way it is being used?

https://www.youtube.com/watch?v=Ul-j5fKfv2k&t=334s

Thanks,

1 Answer
0

Aurora Postgres do use write-ahead log (WAL) buffer to hold transaction data that it later writes to persistent storage. Aurora PostgreSQL writes data in the WAL (write ahead logging) buffer to the log files. The principle of write ahead logging is that the database can't write changes to the data files until after the database writes log records describing those changes to disk. The WAL mechanism reduces disk I/O, and allows Aurora PostgreSQL to use the logs to recover the database after a failure. You can refer to below link to get more insight into it : https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Tuning.concepts.html#AuroraPostgreSQL.Tuning.concepts.WAL

AWS
Anzee
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions