Re: Checksums by default?

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Checksums by default?
Date: 2017-01-24 01:15:53
Message-ID: b3d14910-3868-a107-e7ec-a552435cbefa@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 1/23/17 6:55 PM, Stephen Frost wrote:
> * Jim Nasby (Jim(dot)Nasby(at)BlueTreble(dot)com) wrote:
>> As others have mentioned, right now practically no one enables this,
>> so we've got zero data on how useful it might actually be.
> Uhm, Peter G just said that Heroku enables this on all their databases
> and have yet to see a false-positive report or an issue with having it
> enabled.
>
> That, plus the reports and evidence we've seen in the past couple days,
> look like a pretty ringing endorsement for having them.
>
> I'll ping the RDS crowd and see if they'll tell me what they're doing
> and what their thoughts are on it.

Oh, I read the thread as "there's no data to support checksums are
useful", not "there's no data to support there's little risk of bugs or
false-positives". I certainly agree that Heroku is a good test of both
of those.

IIRC Grant's mentioned in one of his presentations that they enable
checksums, but getting more explicit info would be good.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-01-24 01:23:17 Re: [COMMITTERS] pgsql: Add function to import operating system collations
Previous Message Tom Lane 2017-01-24 01:15:43 Re: Checksums by default?