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