If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.
Use the link below to get a 60% OFF.
PostgreSQL High-Performance Tuning Guide - Full Course
https://www.udemy.com/course/postgres...
Checkpoints are points in the sequence of transactions at which it is guaranteed that the heap and index data files have been updated with all information written before this checkpoint. At checkpoint time, all dirty data pages are flushed to disk and a special checkpoint record is written to the log file.