Re: any impact to DML sql statements when checkpoint starting

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux