From: Bossart, Nathan <bossa...@amazon.com> > It may be useful for backups taken with the "consistent snapshot" > approach. As noted in the documentation [0], running CHECKPOINT > before taking the snapshot can reduce recovery time. However, users > might wish to avoid the IO spike caused by an immediate checkpoint. > > [0] https://www.postgresql.org/docs/devel/backup-file.html
Ah, understood. I agree that the slow or spread manual checkpoint is good to have. Regards Takayuki Tsunakawa
