Search Postgresql Archives

Re: data checksums

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On 6 Aug 2024, at 18:29, Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
>> On Aug 6, 2024, at 08:11, bruno vieira da silva <brunogiovs@xxxxxxxxx> wrote:

>> the pg doc 
>> mentions a considerable performance penality, how considerable it is?
> 
> That line is probably somewhat out of date at this point.  We haven't seen a significant slowdown in enabling them on any modern hardware.  I always turn them on, except on the type of filesystems/hardware mentioned above.

The last in-depth analysis of data checksums (and hint bits) overhead that I
can remember is from 2019:

  https://www.postgresql.org/message-id/20190330192543.GH4719%40development

Hardware advances in the last five years may very well have made these findings
irrelevant however.

--
Daniel Gustafsson







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux