PostgreSQL uses different types of WAL records for recording activities happening on the database. A deeper understanding of what they are, how they are synchronized, what the optimization opportunities are, etc., can lead to a better-tuned system.
This talk also discusses the different sets of PostgreSQL parameters and their impact on WAL and optimization considerations for a high-performance database.
Related Videos: PostgreSQLWhy PostgreSQL Is Becoming A Migration Target For Enterprise
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020
pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020
Security and Traceability on Distributed Database Systems - Julien Riou - Percona Live ONLINE 2020
A Look at the Elephant's Trunk PostgreSQL 13 - Magnus Hagander
The Democratization of Databases - Bruce Momjian