Re: any impact to DML sql statements when checkpoint starting

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: any impact to DML sql statements when checkpoint starting
Дата
Msg-id CAKFQuwbiYtEaiv-Q-Zj_h+g0jp0s6SfB15_EdXG=bZ_VuuDb+A@mail.gmail.com
обсуждение исходный текст
Ответ на any impact to DML sql statements when checkpoint starting  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Ответы RE: any impact to DML sql statements when checkpoint starting  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Список pgsql-admin
Дерево обсуждения
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.

David J.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: any impact to DML sql statements when checkpoint starting
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: any impact to DML sql statements when checkpoint starting