public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael Paquier <[email protected]>
To: Dylan Luong <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: pg_rewind - enable wal_log_hints or data-checksums
Date: Mon, 5 Jun 2017 10:38:04 +0900
Message-ID: <CAB7nPqSHTf3Hb08+cdnFUprtNNLS0jLvzyivDMiV7+j0a2Lcng@mail.gmail.com> (raw)
In-Reply-To: <f9be7f2023784cbbb58255b0d9ea8281@ITUPW-EXMBOX2B.UniNet.unisa.edu.au>
References: <f9be7f2023784cbbb58255b0d9ea8281@ITUPW-EXMBOX2B.UniNet.unisa.edu.au>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-general>
On Mon, Jun 5, 2017 at 9:37 AM, Dylan Luong <[email protected]> wrote:
> pg_rewind requires that the target server either has the wal_log_hints
> option enabled in postgresql.conf or data checksums enabled when the cluster
> was initialized with initdb.
Yes, this is to make sure that you don't finish with a corrupted
target server if a hint bit is set on a page after a checkpoint. Any
of those options make sure that a full-page write is generated in this
case.
> What is the difference between the two options?
Data checksums calculate 2 bytes of checksum data and write it to each
page that is evicted from shared buffers. Each page read from disk has
its checksum checked. In some workloads, like a heavy read load where
a lot of page evictions happen, this can induce a couple of percents
of performance lost. In my own experience, that's 1~2%.
> What are the advantages and disadvantages between the two?
> Which one is the the preferred option?
If you care more about performance or if you use a file system that
has its own block-level checksum, wal_log_hints would be preferred.
Data checksums offer more guarantees in terms of integrity though when
looking for corrupted data. Things get found more quickly.
--
Michael
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_rewind - enable wal_log_hints or data-checksums
In-Reply-To: <CAB7nPqSHTf3Hb08+cdnFUprtNNLS0jLvzyivDMiV7+j0a2Lcng@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox