Is parameter "--data-checksums" recommended to be turned on?

[ts101]

My system is PostgreSQL 15.5 with TimeScale 2.12.2 on-prem.
Command SHOW data_checksums displays “off”.

I am reading articles:

• pro setting: postgres.ai in chapter 7 (2023)
• pro setting: crunchydata (2021)
• developers some pro, some cons: postgresql.org (2019)

Just wondering:

1. How many installations have this setting “on” and how many “off”.
2. Is it really beneficial to set it “on”?
3. What is performance penalty for TimescaleDB database?
4. What is default setting in cloud version of Timescale? (This will probably tell a lot).

[jonatasdp]

Very interesting observation!

I don’t have all answers but I can easily imagine that it can affect the throughput as it’s a check

I checked one of my cloud instances and it’s off too

I think it has one extra level of consistency that can add to your data. If your business requests such confidence, go for it.