Re: Broken system timekeeping breaks the stats collector - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Broken system timekeeping breaks the stats collector
Date
Msg-id 26209.1339947490@sss.pgh.pa.us
Whole thread Raw
In response to Re: Broken system timekeeping breaks the stats collector  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> Fine, but please log this as a WARNING system time skew detected, so
> we can actually see it has happened rather than just silently
> accepting the situation.

I think elog(LOG) is more appropriate, same as we have for the existing
messages for related complaints.  No one backend is going to have a
complete view of the situation, and the collector itself has to use
LOG since it has no connected client at all.  So the postmaster log
is the place to look for evidence of clock trouble.

> Perhaps we should do the same test at startup to see if the clock has
> gone backwards then also.

Uh ... backwards from what?  And what difference would it make?  We
always force an immediate write of the stats file at startup anyway.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: sortsupport for text
Next
From: Tom Lane
Date:
Subject: Re: libpq compression