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
