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
>
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 |