From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | pinker <pinker(at)onet(dot)eu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Checkpoint write time - anything unusual? |
Date: | 2017-10-03 07:38:31 |
Message-ID: | 1507016311.4156.3.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | milist ujang | 2017-10-03 11:45:17 | BDR, wal sender, high system cpu, mutex_lock_common |
Previous Message | Bruce Momjian | 2017-10-02 22:36:30 | Re: pg_stat_tmp and pg_upgrade |