WAL and checkpoint tuning
Postgres FM
00:00
Understanding Checkpoint Timeout and Wall Generation in Postgres
This chapter explores the concept of checkpoint timeout and its importance in understanding acceptable downtime. It discusses the production speed of wall data and its relation to checkpoint timeout and Maxwell size. The chapter emphasizes the need to measure recovery time and guarantee minimal downtime, as well as the importance of enabling logging of checkpoints.
Transcript
Play full episode
