Re: Weird failure in explain.out with OpenBSD - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Weird failure in explain.out with OpenBSD
Date
Msg-id CA+hUKGKosC0ZUiq7SNjhB6VuTWtLXpw1Te86VBLnYnFn8PXJMQ@mail.gmail.com
Whole thread Raw
In response to Re: Weird failure in explain.out with OpenBSD  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Weird failure in explain.out with OpenBSD
Re: Weird failure in explain.out with OpenBSD
Re: Weird failure in explain.out with OpenBSD
List pgsql-hackers
On Thu, Nov 11, 2021 at 1:15 PM Michael Paquier <michael@paquier.xyz> wrote:
> morepork uses 6.9 now, but it has been recently upgraded from 5.4 or
> a version close to that, right?  I am wondering if 7.0 may help
> regarding this issue.  Postgres is not wrong here.

I dunno.  Clocks on virtualised systems and even metal seem to be a
minefield of quirks and heuristics.  Some discussion, may or may not
be relevant:

https://marc.info/?l=openbsd-tech&m=161657532610882&w=2

Some starter questions for Mikael would be: could you please check
which clock source it's using?, is it under a hypervisor, and if so
which?, what is the CPU model?, what are other kernels choosing when
running as guests on the same hypervisor (if applicable)?  Did
anything interesting happen on either the guest or host operating
system (if not bare metal) some time around 2021-11-10 21:59 CET?

I'm no expert on this stuff but something tells me that a 124ms leap
needs a different explanation than the sub-µs difference reported
earlier...



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: fix warnings in 9.6, 10, 11's contrib when compiling without openssl
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: [BUG]Invalidate relcache when setting REPLICA IDENTITY