Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o47Yd-0001TS-T7 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jun 2022 21:06:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o47Yc-0001ue-9E for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jun 2022 21:06:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o47Yb-0001tv-KJ for pgsql-hackers@lists.postgresql.org; Wed, 22 Jun 2022 21:06:37 +0000 Received: from smtp-fw-80006.amazon.com ([99.78.197.217]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o47YY-00032d-0L for pgsql-hackers@postgresql.org; Wed, 22 Jun 2022 21:06:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1655931995; x=1687467995; h=from:to:subject:date:message-id:content-id: content-transfer-encoding:mime-version; bh=FSjKaXQUlyssvI28qRUGOVtZ9kZzsUod3joLZf2C0xE=; b=lkbM4Ax+7nwt/C7YC9cidPJ3Db3HuAvRD/o+YXvaQN4KP/dogKFpxWyx +45qoZoJ7Lrj92E0BmgB3fy7JYJ1xWem9yMV+JmURJWaUhY6ldp6Wyxki yVPX3TlLDw3neZz/238PhWSac+MxSVH2rEASCMUF7m+jMNJ27orWUrUwM 8=; X-IronPort-AV: E=Sophos;i="5.92,212,1650931200"; d="scan'208";a="100861958" Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-iad-1e-90d70b14.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP; 22 Jun 2022 21:06:33 +0000 Received: from EX13MTAUEE002.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1e-90d70b14.us-east-1.amazon.com (Postfix) with ESMTPS id 9935DC0427 for ; Wed, 22 Jun 2022 21:06:31 +0000 (UTC) Received: from EX13D35UEE004.ant.amazon.com (10.43.62.58) by EX13MTAUEE002.ant.amazon.com (10.43.62.24) with Microsoft SMTP Server (TLS) id 15.0.1497.36; Wed, 22 Jun 2022 21:06:30 +0000 Received: from EX13D35UEE001.ant.amazon.com (10.43.62.13) by EX13D35UEE004.ant.amazon.com (10.43.62.58) with Microsoft SMTP Server (TLS) id 15.0.1497.36; Wed, 22 Jun 2022 21:06:30 +0000 Received: from EX13D35UEE001.ant.amazon.com ([10.43.62.13]) by EX13D35UEE001.ant.amazon.com ([10.43.62.13]) with mapi id 15.00.1497.036; Wed, 22 Jun 2022 21:06:29 +0000 From: "Bagga, Rishu" To: "pgsql-hackers@postgresql.org" Subject: SLRUs in the main buffer pool - Page Header definitions Thread-Topic: SLRUs in the main buffer pool - Page Header definitions Thread-Index: AQHYhnvxezKTgPNs7k2tXj3iuMBOOw== Date: Wed, 22 Jun 2022 21:06:29 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.62.46] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgYWxsLA0KDQpQb3N0Z3JlU1FMIGN1cnJlbnRseSBtYWludGFpbnMgc2V2ZXJhbCBkYXRhIHN0 cnVjdHVyZXMgaW4gdGhlIFNMUlUNCmNhY2hlLiBUaGUgU0xSVSBjYWNoZSBoYXMgc2NhbGluZyBh bmQgc2l6aW5nIGNoYWxsZW5nZXMgYmVjYXVzZSBvZiBpdOKAmXMNCnNpbXBsZSBpbXBsZW1lbnRh dGlvbi4gVGhlIGdvYWwgaXMgdG8gbW92ZSB0aGVzZSBjYWNoZXMgdG8gdGhlIGNvbW1vbg0KYnVm ZmVyIGNhY2hlIHRvIGJlbmVmaXQgZnJvbSB0aGUgc3Ryb25nZXIgY2FwYWJpbGl0aWVzIG9mIHRo ZSBjb21tb24NCmJ1ZmZlcmNhY2hlIGNvZGUuIEF0IEFXUywgd2UgYXJlIGJ1aWxkaW5nIG9uIHRo ZSBwYXRjaCBzaGFyZWQgYnkgVGhvbWFzDQpNdW5ybyBbMV0sIHdoaWNoIHRyZWF0cyB0aGUgU0xS VSBwYWdlcyBhcyBwYXJ0IG9mIGEgcHNldWRvLWRhdGFiYXRhYmUNCm9mIElEIDkuIFdlIHdpbGwg cmVmZXIgdG8gdGhlIHBhZ2VzIGJlbG9uZ2luZyB0byBTTFJVIGNvbXBvbmVudHMgYXMNCkJ1ZmZl cmVkT2JqZWN0IHBhZ2VzIGdvaW5nIGZvcndhcmQuDQoNClRoZSBjdXJyZW50IFNMUlUgcGFnZXMg ZG8gbm90IGhhdmUgYW55IGhlYWRlciwgc28gdGhlcmUgaXMgYSBuZWVkIHRvDQpjcmVhdGUgYSBu ZXcgcGFnZSBoZWFkZXIgZm9ybWF0IGZvciB0aGVzZS4gT3VyIGludmVzdGlnYXRpb25zIHJldmVh bGVkDQp0aGF0IHdlIG5lZWQgdG86DQoNCjEuIHRyYWNrIExTTiB0byBlbnN1cmUgZHVyYWJpbGl0 eSBhbmQgY29uc2lzdGVuY3kgb2YgYWxsIHBhZ2VzIChmb3IgcmVkbw0KwqDCoCBhbmQgZnVsbCBw YWdlIHdyaXRlIHB1cnBvc2VzKQ0KMi4gaGF2ZSBhIGNoZWNrc3VtIChmb3IgcGFnZSBjb3JyZWN0 bmVzcyB2ZXJpZmljYXRpb24pLg0KMy4gQSBmbGFnIHRvIGlkZW50aWZ5IGlmIHRoZSBwYWdlIGlz IGEgcmVsYXRpb25hbCBvciBCdWZmZXJlZE9iamVjdA0KNC4gVHJhY2sgdmVyc2lvbiBpbmZvcm1h dGlvbi4NCg0KV2UgYXJlIHN1Z2dlc3RpbmcgYSBtaW5pbWFsIEJ1ZmZlcmVkT2JqZWN0IHBhZ2Ug aGVhZGVyDQp0byBiZSB0aGUgZm9sbG93aW5nLCBvdmVybGFwcGluZyB3aXRoIHRoZSBrZXkgZmll bGRzIG5lYXIgdGhlIGJlZ2lubmluZw0Kb2YgdGhlIHJlZ3VsYXIgUGFnZUhlYWRlckRhdGE6DQoN CnR5cGVkZWYgc3RydWN0IEJ1ZmZlcmVkT2JqZWN0UGFnZUhlYWRlckRhdGENCnsNCsKgIMKgIFBh Z2VYTG9nUmVjUHRyIHBkX2xzbjsNCsKgIMKgIHVpbnQxNl90IMKgIMKgIMKgIHBkX2NoZWNrc3Vt Ow0KwqAgwqAgdWludDE2X3QgwqAgwqAgwqAgcGRfZmxhZ3M7DQrCoCDCoCB1aW50MTZfdCDCoCDC oCDCoCBwZF9wYWdlc2l6ZV92ZXJzaW9uOw0KfSBCdWZmZXJlZE9iamVjdFBhZ2VIZWFkZXJEYXRh Ow0KDQpGb3IgcmVmZXJlbmNlLCB0aGUgcmVndWxhciBwYWdlIGhlYWRlciBsb29rcyBsaWtlIHRo ZSBmb2xsb3dpbmc6DQp0eXBlZGVmIHN0cnVjdCBQYWdlSGVhZGVyRGF0YQ0Kew0KwqAgwqAgUGFn ZVhMb2dSZWNQdHLCoCDCoCBwZF9sc247DQrCoCDCoCB1aW50MTZfdMKgIMKgIHBkX2NoZWNrc3Vt Ow0KwqAgwqAgdWludDE2X3TCoCDCoCBwZF9mbGFnczsNCsKgIMKgIExvY2F0aW9uSW5kZXggwqAg cGRfbG93ZXI7DQrCoCDCoCBMb2NhdGlvbkluZGV4IMKgIHBkX3VwcGVyOw0KwqAgwqAgTG9jYXRp b25JbmRleCDCoCBwZF9zcGVjaWFsOw0KwqAgwqAgdWludDE2X3QgwqAgwqAgwqAgwqAgwqAgcGRf cGFnZXNpemVfdmVyc2lvbjsNCsKgIMKgIFRyYW5zYWN0aW9uSWQgwqAgcGRfcHJ1bmVfeGlkOw0K wqDCoMKgwqBJdGVtSWREYXRhQ29tbW9uwqAgcGRfbGlucFtdOw0KfSBQYWdlSGVhZGVyRGF0YTsN Cg0KQWZ0ZXIgY2FyZWZ1bCByZXZpZXcsIHdlIGhhdmUgdHJpbW1lZCBvdXQgdGhlIGhlYXAgYW5k IGluZGV4IHNwZWNpZmljDQpmaWVsZHMgZnJvbSB0aGUgc3VnZ2VzdGVkIGhlYWRlciB0aGF0IGRv IG5vdCBhZGQgYW55IHZhbHVlIHRvIFNMUlUNCmNvbXBvbmVudHMuIFdlIHBsYW4gdG8gdXNlIHBk X2xzbiwgcGRfY2hlY2tzdW0sIGFuZCBwZF9wYWdlc2l6ZV92ZXJzaW9uDQppbiB0aGUgc2FtZSB3 YXkgdGhhdCB0aGV5IGFyZSBpbiByZWxhdGlvbmFsIHBhZ2VzLiBUaGVzZSBmaWVsZHMgYXJlDQpu ZWVkZWQgdG8gZW5zdXJlIGNvbnNpc3RlbmN5LCBkdXJhYmlsaXR5IGFuZCBwYWdlIGNvcnJlY3Ru ZXNzLg0KDQpXZSB3aWxsIHVzZSB0aGUgNHRoIGJpdCBvZiBwZF9mbGFncyB0byBpZGVudGlmeSBh IEJ1ZmZlcmVkT2JqZWN0IHBhZ2UuDQpJZiB0aGUgYml0IGlzIHNldCB0aGVuIHRoaXMgZGVub3Rl cyBhIEJ1ZmZlcmVkT2JqZWN0IHBhZ2UuIFRvZGF5LCBiaXRzDQoxIC0gMyBhcmUgdXNlZCBmb3Ig ZGV0ZXJtaW5pbmcgaWYgdGhlcmUgYXJlIGFueSBmcmVlIGxpbmUgcG9pbnRlcnMsIGlmDQp0aGUg cGFnZSBpcyBmdWxsLCBhbmQgaWYgYWxsIHR1cGxlcyBvbiB0aGUgcGFnZSBhcmUgdmlzaWJsZSB0 bw0KZXZlcnlvbmUsIHJlc3BlY3RpdmVseS4gV2Ugd2lsbCB1c2UgdGhpcyBpbmZvcm1hdGlvbiBh Y2NvcmRpbmdseSBpbiB0aGUNCnN0b3JhZ2UgbWFuYWdlciB0byBkZXRlcm1pbmUgd2hpY2ggY2Fs bGJhY2sgZnVuY3Rpb25zIHRvIHVzZSBmb3IgZmlsZQ0KSS9PIG9wZXJhdGlvbnMuIFRoaXMgYXBw cm9hY2ggYWxsb3dzIHRoZSBidWZmZXJjYWNoZSB0byBoYXZlIGFuDQp1bml2ZXJzYWwgbWV0aG9k IHRvIHF1aWNrbHkgZGV0ZXJtaW5lIHdoYXQgdHlwZSBvZiBwYWdlIGl0IGlzIGRlYWxpbmcNCndp dGggYXQgYW55IHRpbWUuDQoNClVzaW5nIHRoZSBuZXcgQnVmZmVyZWRPYmplY3QgcGFnZSBoZWFk ZXIgd2lsbCBiZSBzcGFjZSBlZmZpY2llbnQgYnV0DQppbnRyb2R1Y2VzIGEgc2lnbmlmaWNhbnQg Y2hhbmdlIGluIHRoZSBjb2RlYmFzZSB0byBub3cgdHJhY2sgdHdvIHR5cGVzDQpvZiBwYWdlIGhl YWRlciBkYXRhLiBEdXJpbmcgdXBncmFkZSwgYWxsIFNMUlUgZmlsZXMgdGhhdCBleGlzdCBvbiB0 aGUNCnN5c3RlbSBtdXN0IGJlIGNvbnZlcnRlZCB0byB0aGUgbmV3IGZvcm1hdCB3aXRoIHBhZ2Ug aGVhZGVyLiBUaGlzIHdpbGwNCnJlcXVpcmUgcmV3cml0aW5nIGFsbCB0aGUgU0xSVSBwYWdlcyB3 aXRoIHRoZSBwYWdlIGhlYWRlciBhcyBwYXJ0IG9mDQpwZ191cGdyYWRlLg0KDQpXZSBiZWxpZXZl IHRoYXQgdGhpcyBpcyB0aGUgY29ycmVjdCBhcHByb2FjaCBmb3IgdGhlIGxvbmcgcnVuLiBXZSB3 b3VsZA0KbG92ZSBmZWVkYmFjayBpZiB0aGVyZSBhcmUgYWRkaXRpb25hbCBpdGVtcyBvZiBkYXRh IHRoYXQgc2hvdWxkIGJlDQp0cmFja2VkIGFzIHdlbGwuIEFsdGVybmF0aXZlbHksIHdlIGNvdWxk IHJlLXVzZSB0aGUgZXhpc3RpbmcgcGFnZQ0KaGVhZGVyIGFuZCB0aGUgdW51c2VkIGZpZWxkcyBj b3VsZCBiZSB1c2VkIGFzIGEgcGFkZGluZy4gVGhpcyBmZWVscw0KbGlrZSBhbiB1bmNsZWFuIGFw cHJvYWNoIGJ1dCB3b3VsZCBhdm9pZCBoYXZpbmcgdHdvIHBhZ2UgaGVhZGVyIHR5cGVzDQppbiB0 aGUgZGF0YWJhc2UuDQoNCg0KDQpbMV0gLcKgaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVz c2FnZS1pZC9mbGF0L0NBK2hVS0dLQVl6ZTk5Qi1qazlOb01wLTJCRHFBZ2lSQzRvSnYrYkZ4Z2hO Z2RpZXE4UUBtYWlsLmdtYWlsLmNvbQ0KDQoNCg0KRGlzY3Vzc2VkIHdpdGg6IEpvZSBDb253YXks IE5hdGhhbiBCb3NzYXJ0LCBTaGF3biBEZWJuYXRoDQoNCg0KUmlzaHUgQmFnZ2ENCg0KQW1hem9u IFdlYiBTZXJ2aWNlcyAoQVdTKQ0KDQoNCg0K