On Thu, Feb 3, 2022 at 5:29 PM James Pang (chaolpan) <chaolpan@cisco.com> wrote:
Any impact to DML(insert,update,delete,commit) when checkpoint starting , not sure any lock waiting ?
Checkpoints consume disk I/O. If the pages your DML are touching are not already in shared memory, getting them there also consumes I/O. The WAL writing consumes I/O.
I would expect some possible (but I'd think minor) contention if the changes are touching the same buffer pages that are being flushed to disk. But pages are fairly small individually.