Re: [GENERAL] Checkpoint write time - anything unusual?

pinker wrote:
> I've just run pgBadger on my pg logs and wonder if those checkpoint
> statistics is something I should worry about or not?
> The highest write time is about 47 minutes but I'm not sure if that's
> checkpoint_completion_target*checkpoint_target value or real time between
> sending the command to write and getting response?
> If that's the first one - then I assume everything is ok because:
>  checkpoint_timeout = 8min
>  checkpoint_completion_target = 0.9
> 
> but I'm not sure which value it is...

I think that is fine.

if checkpoint_completion_target is 0.9, spending 0.9 * 3600 = 3240
seconds
per hour doing checkpoints would be normal.

The whole point of this parameter is to spread checkpoints across
a longer time to avoid I/O spikes.

Yours,
Laurenz Albe


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general