Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZHLuA-0007qc-PW for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2015 00:59:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZHLuA-00015I-Bd for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2015 00:59:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZHLu9-000150-Nw for pgsql-docs@postgresql.org; Tue, 21 Jul 2015 00:59:33 +0000 Received: from mail-qg0-x234.google.com ([2607:f8b0:400d:c04::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZHLu7-0002KS-4R for pgsql-docs@postgresql.org; Tue, 21 Jul 2015 00:59:32 +0000 Received: by qged69 with SMTP id d69so51796187qge.0 for ; Mon, 20 Jul 2015 17:59:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=BrrxsnGHKhX09fwH/gWSkky01o3D6dThDKO982/Jweo=; b=0BdMwjzh2Mc1mWz7yZVMAxd5szTGiKdB+dnyLYokQ8u6iFdFkvT0gL1MWxk7epu/lH MAwaP95ds9LrCg/06m1bGQ7klTAd4rt48hff2OVjsJ+vJeA+NFO2A5vYPeV0XvIBp+H9 P5I76s3/Qt2gHd6Ns13moR6d36Q4mfr7prGujHNVnqKBGDseqImD5rHaGl4rTyO55kyf P+U/uu8GEu7QaY61Hh1IsYac8kx8UKRDM68m3LJjd/yS+W3kA8CZkCSDEAbD0452vzgS S2xWXFJeE7LjMnkTWha708hgZsB2gOzHIFsrNbXiYzCiL6sAf9PUR9NtNMACrt7g3D0a Mstg== MIME-Version: 1.0 X-Received: by 10.140.35.243 with SMTP id n106mr33959144qgn.11.1437440370302; Mon, 20 Jul 2015 17:59:30 -0700 (PDT) Received: by 10.140.107.4 with HTTP; Mon, 20 Jul 2015 17:59:30 -0700 (PDT) In-Reply-To: References: Date: Tue, 21 Jul 2015 09:59:30 +0900 Message-ID: Subject: Re: Possible mistake in Section 63.6 - 9.6devel Documentation From: Michael Paquier To: Vignesh Raghunathan Cc: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=001a1130c0a2a88d24051b582a50 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --001a1130c0a2a88d24051b582a50 Content-Type: text/plain; charset=UTF-8 On Tue, Jul 21, 2015 at 6:54 AM, Vignesh Raghunathan wrote: > Hello, > > It has been mentioned in Section 63.6 that the first two fields in > PageHeaderData track the most recent WAL entry related to the page. However, > I am not sure how pd_checksum is related to WAL. Could it be possible that > the sentence has been carried over from previous versions of the > documentations without considering the change to the second field in > PageHeaderData? Yes, the documentation is mistaken. The two bytes of pd_tli have been switched to pd_checksum in 9.3, hence only the first field is relevant for WAL, aka pd_lsn. Looking at this portion of the docs I think that it should be updated as attached, mentioning pd_checksum as well. -- Michael --001a1130c0a2a88d24051b582a50 Content-Type: text/x-patch; charset=US-ASCII; name="20150721_pageheader_docfix.patch" Content-Disposition: attachment; filename="20150721_pageheader_docfix.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iccmvnyz0 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9zdG9yYWdlLnNnbWwgYi9kb2Mv c3JjL3NnbWwvc3RvcmFnZS5zZ21sCmluZGV4IGU1YjdiNGIuLjA3M2ZlMmIg MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9zdG9yYWdlLnNnbWwKKysrIGIv ZG9jL3NyYy9zZ21sL3N0b3JhZ2Uuc2dtbApAQCAtNzU4LDE4ICs3NTgsMTgg QEAgZGF0YS4gRW1wdHkgaW4gb3JkaW5hcnkgdGFibGVzLjwvZW50cnk+CiAg PHBhcmE+CiAKICAgVGhlIGZpcnN0IDI0IGJ5dGVzIG9mIGVhY2ggcGFnZSBj b25zaXN0cyBvZiBhIHBhZ2UgaGVhZGVyCi0gIChQYWdlSGVhZGVyRGF0YSku IEl0cyBmb3JtYXQgaXMgZGV0YWlsZWQgaW4gPHhyZWYKLSAgbGlua2VuZD0i cGFnZWhlYWRlcmRhdGEtdGFibGUiPi4gVGhlIGZpcnN0IHR3byBmaWVsZHMg dHJhY2sgdGhlIG1vc3QKLSAgcmVjZW50IFdBTCBlbnRyeSByZWxhdGVkIHRv IHRoaXMgcGFnZS4gTmV4dCBpcyBhIDItYnl0ZSBmaWVsZAotICBjb250YWlu aW5nIGZsYWcgYml0cy4gVGhpcyBpcyBmb2xsb3dlZCBieSB0aHJlZSAyLWJ5 dGUgaW50ZWdlciBmaWVsZHMKLSAgKDxzdHJ1Y3RmaWVsZD5wZF9sb3dlcjwv c3RydWN0ZmllbGQ+LCA8c3RydWN0ZmllbGQ+cGRfdXBwZXI8L3N0cnVjdGZp ZWxkPiwKLSAgYW5kIDxzdHJ1Y3RmaWVsZD5wZF9zcGVjaWFsPC9zdHJ1Y3Rm aWVsZD4pLiBUaGVzZSBjb250YWluIGJ5dGUgb2Zmc2V0cwotICBmcm9tIHRo ZSBwYWdlIHN0YXJ0IHRvIHRoZSBzdGFydAotICBvZiB1bmFsbG9jYXRlZCBz cGFjZSwgdG8gdGhlIGVuZCBvZiB1bmFsbG9jYXRlZCBzcGFjZSwgYW5kIHRv IHRoZSBzdGFydCBvZgotICB0aGUgc3BlY2lhbCBzcGFjZS4KLSAgVGhlIG5l eHQgMiBieXRlcyBvZiB0aGUgcGFnZSBoZWFkZXIsCi0gIDxzdHJ1Y3RmaWVs ZD5wZF9wYWdlc2l6ZV92ZXJzaW9uPC9zdHJ1Y3RmaWVsZD4sIHN0b3JlIGJv dGggdGhlIHBhZ2Ugc2l6ZQotICBhbmQgYSB2ZXJzaW9uIGluZGljYXRvci4g IEJlZ2lubmluZyB3aXRoCisgICg8c3RydWN0bmFtZT5QYWdlSGVhZGVyRGF0 YTwvPikuIEl0cyBmb3JtYXQgaXMgZGV0YWlsZWQgaW4gPHhyZWYKKyAgbGlu a2VuZD0icGFnZWhlYWRlcmRhdGEtdGFibGUiPi4gVGhlIGZpcnN0IGZpZWxk IHRyYWNrcyB0aGUgbW9zdAorICByZWNlbnQgV0FMIGVudHJ5IHJlbGF0ZWQg dG8gdGhpcyBwYWdlLiBUaGUgc2Vjb25kIGZpZWxkIGNvbnRhaW5zCisgIHRo ZSBwYWdlIGNoZWNrc3VtIGlmIDx4cmVmIGxpbmtlbmQ9ImFwcC1pbml0ZGIt ZGF0YS1jaGVja3N1bXMiPiBhcmUKKyAgZW5hYmxlZC4gIE5leHQgaXMgYSAy LWJ5dGUgZmllbGQgY29udGFpbmluZyBmbGFnIGJpdHMuIFRoaXMgaXMgZm9s bG93ZWQKKyAgYnkgdGhyZWUgMi1ieXRlIGludGVnZXIgZmllbGRzICg8c3Ry dWN0ZmllbGQ+cGRfbG93ZXI8L3N0cnVjdGZpZWxkPiwKKyAgPHN0cnVjdGZp ZWxkPnBkX3VwcGVyPC9zdHJ1Y3RmaWVsZD4sIGFuZAorICA8c3RydWN0Zmll bGQ+cGRfc3BlY2lhbDwvc3RydWN0ZmllbGQ+KS4gIFRoZXNlIGNvbnRhaW4g Ynl0ZSBvZmZzZXRzCisgIGZyb20gdGhlIHBhZ2Ugc3RhcnQgdG8gdGhlIHN0 YXJ0IG9mIHVuYWxsb2NhdGVkIHNwYWNlLCB0byB0aGUgZW5kIG9mCisgIHVu YWxsb2NhdGVkIHNwYWNlLCBhbmQgdG8gdGhlIHN0YXJ0IG9mIHRoZSBzcGVj aWFsIHNwYWNlLiAgVGhlIG5leHQgMgorICBieXRlcyBvZiB0aGUgcGFnZSBo ZWFkZXIsIDxzdHJ1Y3RmaWVsZD5wZF9wYWdlc2l6ZV92ZXJzaW9uPC9zdHJ1 Y3RmaWVsZD4sCisgIHN0b3JlIGJvdGggdGhlIHBhZ2Ugc2l6ZSBhbmQgYSB2 ZXJzaW9uIGluZGljYXRvci4gIEJlZ2lubmluZyB3aXRoCiAgIDxwcm9kdWN0 bmFtZT5Qb3N0Z3JlU1FMPC9wcm9kdWN0bmFtZT4gOC4zIHRoZSB2ZXJzaW9u IG51bWJlciBpcyA0OwogICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJv ZHVjdG5hbWU+IDguMSBhbmQgOC4yIHVzZWQgdmVyc2lvbiBudW1iZXIgMzsK ICAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3RuYW1lPiA4LjAg dXNlZCB2ZXJzaW9uIG51bWJlciAyOwo= --001a1130c0a2a88d24051b582a50 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --001a1130c0a2a88d24051b582a50--