Architectural overview of PostgreSQL internals, including process and memory architecture, the write-ahead log, MVCC, the buffer manager, and how these mechanics behave when running on Amazon RDS and Aurora PostgreSQL.