Re: Checksum errors in pg_stat_database - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Checksum errors in pg_stat_database
Date
Msg-id 20190404042240.GI7693@paquier.xyz
Whole thread Raw
In response to Re: Checksum errors in pg_stat_database  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Checksum errors in pg_stat_database
List pgsql-hackers
On Wed, Apr 03, 2019 at 11:56:14AM +0200, Julien Rouhaud wrote:
> But there's still the problem of reporting errors on shared relation,
> so pg_stat_database doesn't really fit for that.  If we go with a
> checksum centric view, it'd be strange to have some of the counters in
> another view.

Having pg_stat_database filled with a phantom row full of NULLs to
track checksum failures of shared objects would be confusing I think.
I personally quite like the separate view approach, with one row per
database, but one opinion does not stand as an agreement.

Anyway, even if we have no agreement on the shape of what we'd like to
do, I don't think that HEAD is in a proper shape now because we just
don't track a portion of the objects which could have checksum
failures.  So we should either revert the patch currently committed,
or add tracking for shared objects, but definitely not keep the code
in a state in-between.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Shawn Debnath
Date:
Subject: Re: Refactoring the checkpointer's fsync request queue
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation