On Thu, Feb 3, 2022 at 5:29 PM James Pang (chaolpan) <chaolpan(at)cisco(dot)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.
David J.