Default ie. 5 minutes
Le mar. 28 déc. 2021 à 19:34, Tom Lane a écrit :
> Marc Millas writes:
> > checkpoint completion target is 0.9
>
> checkpoint_timeout is the more interesting number here.
>
> regards, tom lane
>
Marc Millas writes:
> checkpoint completion target is 0.9
checkpoint_timeout is the more interesting number here.
regards, tom lane
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 wrote:
> Marc Millas 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
Marc Millas 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
