From: | Thomas Poty <thomas(dot)poty(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Andreas Joseph Krogh <andreas(at)visena(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums |
Date: | 2018-01-10 20:23:26 |
Message-ID: | CAN_ctnjM63ndjeZXSPgt18QRa-aqHQu2i4bJkKNdDjATwrqEVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
A question seems to be, according to me, important :
How a corruption, detected thanks to data-checksums, is fixed?
Thank you,
Thomas
Le 10 janv. 2018 20:39, "Andres Freund" <andres(at)anarazel(dot)de> a écrit :
> On 2018-01-09 20:51:17 -0500, Stephen Frost wrote:
> > Greetings,
> >
> > * Andreas Joseph Krogh (andreas(at)visena(dot)com) wrote:
> > > Aha, so enabling CRC causes hint-bits to be written causing extra
> WAL-logging,
> > > which woudn't be the case without CRC enabled?
> > > Thanks for pointing that out.
> >
> > Yes, having checksums enabled forces logging of hint bits. You can
> > enable wal_log_hints independently too, without having checksums, to see
> > what kind of an impact it'll have on your environment.
> >
> > A useful documentation update might be:
> >
> > ---
> > With checksums enabled, wal_log_hints <link to the GUC's documentation>
> > will be enabled and each page read or write will involve calculating the
> > checksum for the page.
> > ---
> >
> > I'd probably just replace the "Enabling checksums may incur a noticeable
> > performance penalty" with the above, as it should be clear that doing
> > more work implies an impact on performance and that avoids the whole
> > question of trying to characterize in a general way something that can't
> > be generalized (as it's workload dependent).
>
> -1. I think this is underplaying the cost.
>
> Greetings,
>
> Andres Freund
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2018-01-10 21:36:42 | Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums |
Previous Message | Andres Freund | 2018-01-10 19:39:21 | Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums |