Hi Tom, checkpoint completion target is 0.9
Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Dec 28, 2021 at 6:46 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Marc Millas <marc.mil...@mokadb.com> writes: > > I am looking at a postgres 9.6 on rh7 > > I see that checkpoint_write_time is huge which looks quite strange as the > > average amount of data written is not that big. > > checkpoint_write_time is not the amount of time spent doing I/O; > it's the elapsed wall-clock time in the write phase. If the I/O > is being throttled because of an un-aggressive checkpoint completion > target, it could be a lot more than the actual I/O time. What have > you got your checkpoint parameters set to? > > regards, tom lane >
