Re: 9.6 write time

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 9.6 write time
Date: 2021-12-28 17:55:47
Message-ID: CADX_1aYE46k6rSs=geRXHg1cuLExO1Y-2mQrCqhyPm-xv-D9HA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Marc Millas <marc(dot)millas(at)mokadb(dot)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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2021-12-28 18:34:18 Re: 9.6 write time
Previous Message Tom Lane 2021-12-28 17:46:44 Re: 9.6 write time