Aug 13, 2020
Percona Tech Days
Jobin Augustine
Jobin Augustine present "Understanding and Optimizing commit sychronization for maximum performance"
Durability by PostgreSQL is taken for granted. PostgreSQL allows it to be tweaked at different levels. A better understanding of the commit synchronization and how it interacts with standby databases can help to optimize the performance while achieving the desired durability.
-Interaction with OS
-Interaction with the Disk system
-Flush / Synch Options
-WAL Records
-Discussion about Remote write, flush and apply stages
-Parameters and Monitoring
-Synchronous standbys
-Performance considerations
Durability by PostgreSQL is taken for granted. PostgreSQL allows it to be tweaked at different levels. A better understanding of the commit synchronization and how it interacts with standby databases can help to optimize the performance while achieving the desired durability.
-Interaction with OS
-Interaction with the Disk system
-Flush / Synch Options
-WAL Records
-Discussion about Remote write, flush and apply stages
-Parameters and Monitoring
-Synchronous standbys
-Performance considerations
About the Author
