On 01/21/2017 04:18 PM, Petr Jelinek wrote:
On 21/01/17 11:39, Magnus Hagander wrote:
Is it time to enable checksums by default, and give initdb a switch to
turn it off instead?

I'd like to see benchmark first, both in terms of CPU and in terms of
produced WAL (=network traffic) given that it turns on logging of hint bits.

... and those hint bits may easily trigger full-page writes, resulting in significant write amplification.


Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to