From: | rihad <rihad(at)mail(dot)ru> |
---|---|
To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: "Time of latest checkpoint" stays too old on both master and slave |
Date: | 2019-06-30 17:55:09 |
Message-ID: | aa16b98a-9eaf-d3a8-5d10-79bb6492e86c@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/30/2019 09:45 PM, Andrew Gierth wrote:
>>>>>> "rihad" == rihad <rihad(at)mail(dot)ru> writes:
> rihad> There's a weird problem, even when the time is initially set by
> rihad> openntpd it keeps lagging by one second every few seconds:
>
> rihad> $ sudo /usr/local/etc/rc.d/openntpd restart
>
> What OS is this?
>
> I've seen this kind of thing with FreeBSD where the kernel timecounter
> source has been chosen badly (i.e. choosing TSC when the TSC isn't
> actually invariant enough). Forcing TSC not to be used fixes it. The
> configuration I've especially noticed it on is when running in a VM with
> a single virtual CPU.
>
Exactly. You're right. It's on FreeBSD 11.2. After some googling earlier
I changed kern.timecounter.hardware=HPET and solved the problem. The
default chosen value TSC-low seems to misbehave for this box, although
it works on others (running the same FreeBSD version).
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2019-07-01 07:12:51 | Re: iterate over partitions |
Previous Message | Andrew Gierth | 2019-06-30 17:45:03 | Re: "Time of latest checkpoint" stays too old on both master and slave |