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 1oZLte-0001Wj-Sd for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Sep 2022 00:41:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oZLtd-0000E3-2h for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Sep 2022 00:41:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oZLtc-0000Du-N4 for pgsql-hackers@lists.postgresql.org; Sat, 17 Sep 2022 00:41:24 +0000 Received: from smtp-fw-80006.amazon.com ([99.78.197.217]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oZLtY-0007U4-8i for pgsql-hackers@postgresql.org; Sat, 17 Sep 2022 00:41:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1663375281; x=1694911281; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=aeELP3SO3rflgEw2bke8rzzP1aQkOEDD+2MRGdh1MRo=; b=ZLYA1okgK+nhBfu3mOSzV9I/Q/ebeDWxp/jJEPyCWM4xYBJ6l1MkgV+M LHNcOjgLazjMGNngICwynRZ3CRX1r74eIIO/jjnvVUZ9mvEHYWMMNDrT8 VnB4l4JYeYqNtwLGiq7rjM0oM6rYwFLLhb35MXW3JLmJ0S4m5Lm7iIurh A=; X-IronPort-AV: E=Sophos;i="5.93,321,1654560000"; d="scan'208";a="130966786" Subject: Re: SLRUs in the main buffer pool, redux Thread-Topic: SLRUs in the main buffer pool, redux Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-iad-1d-b48bc93b.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 17 Sep 2022 00:41:18 +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-1d-b48bc93b.us-east-1.amazon.com (Postfix) with ESMTPS id D6E81C08C4; Sat, 17 Sep 2022 00:41:15 +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.38; Sat, 17 Sep 2022 00:41:15 +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.38; Sat, 17 Sep 2022 00:41:15 +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.040; Sat, 17 Sep 2022 00:41:14 +0000 From: "Bagga, Rishu" To: Thomas Munro , Heikki Linnakangas CC: pgsql-hackers Thread-Index: AQHYyi2rSHoBzX/TZkWWSAGI4e/tnK3iUq0A Date: Sat, 17 Sep 2022 00:41:14 +0000 Message-ID: <1B2B5DB8-7BEE-489E-AEF8-79BE92E07C3F@amazon.com> References: <5ced6199-9fa2-722c-2163-4418ca907a95@iki.fi> In-Reply-To: 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.61.49] 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 SGkgVGhvbWFzLA0KDQpXaGlsZSBJIHdhcyB3b3JraW5nIG9uIGFkZGluZyB0aGUgcGFnZSBoZWFk ZXJzIHRvIFNMUlUgcGFnZXMgb24geW91ciBwYXRjaCwgSSBjYW1lIGFjcm9zcyB0aGlzIGNvZGUg d2hlcmUgaXQgc2VlbXMgbGlrZSAiTXVsdGlYYWN0SWRUb01lbWJlclBhZ2UiIGlzIG1pc3Rha2Vu bHkgYmVpbmcgdXNlZCBpbnN0ZWFkIG9mIE11bHRpWGFjdElkVG9PZmZzZXRQYWdlIGluIHRoZSBU cmltTXVsdGlYYWN0IGZ1bmN0aW9uLg0KDQpCZWxvdyBpcyB0aGUgYXJlYSBvZiBjb25jZXJuIGlu IHRoZSBwYXRjaDoNCg0KQEAgLTIwNDUsMTQgKzE5NzcsNyBAQCBUcmltTXVsdGlYYWN0KHZvaWQp DQogCW9sZGVzdE1YYWN0REIgPSBNdWx0aVhhY3RTdGF0ZS0+b2xkZXN0TXVsdGlYYWN0REI7DQog CUxXTG9ja1JlbGVhc2UoTXVsdGlYYWN0R2VuTG9jayk7DQogDQotCS8qIENsZWFuIHVwIG9mZnNl dHMgc3RhdGUgKi8NCi0JTFdMb2NrQWNxdWlyZShNdWx0aVhhY3RPZmZzZXRTTFJVTG9jaywgTFdf RVhDTFVTSVZFKTsNCi0NCi0JLyoNCi0JICogKFJlLSlJbml0aWFsaXplIG91ciBpZGVhIG9mIHRo ZSBsYXRlc3QgcGFnZSBudW1iZXIgZm9yIG9mZnNldHMuDQotCSAqLw0KLQlwYWdlbm8gPSBNdWx0 aVhhY3RJZFRvT2Zmc2V0UGFnZShuZXh0TVhhY3QpOw0KLQlNdWx0aVhhY3RPZmZzZXRDdGwtPnNo YXJlZC0+bGF0ZXN0X3BhZ2VfbnVtYmVyID0gcGFnMGVubzsNCisJcGFnZW5vID0gTVhPZmZzZXRU b01lbWJlclBhZ2Uob2Zmc2V0KTsNCg0KDQpMZXQgdXMga25vdyBpZiBJIGFtIG1pc3Npbmcgc29t ZXRoaW5nIGhlcmUgb3IgaWYgaXQgaXMgYW4gZXJyb3IuDQoNClNpbmNlcmVseSwNCg0KUmlzaHUg QmFnZ2EgKEFtYXpvbiBXZWIgU2VydmljZXMpDQoNCu+7v09uIDkvMTYvMjIsIDU6MzcgUE0sICJU aG9tYXMgTXVucm8iIDx0aG9tYXMubXVucm9AZ21haWwuY29tPiB3cm90ZToNCg0KICAgIENBVVRJ T046IFRoaXMgZW1haWwgb3JpZ2luYXRlZCBmcm9tIG91dHNpZGUgb2YgdGhlIG9yZ2FuaXphdGlv bi4gRG8gbm90IGNsaWNrIGxpbmtzIG9yIG9wZW4gYXR0YWNobWVudHMgdW5sZXNzIHlvdSBjYW4g Y29uZmlybSB0aGUgc2VuZGVyIGFuZCBrbm93IHRoZSBjb250ZW50IGlzIHNhZmUuDQoNCg0KDQog ICAgUmViYXNlZCwgZGVidWdnZWQgYW5kIGZsZXNoZWQgb3V0IGEgdGlueSBiaXQgbW9yZSwgYnV0 IHN0aWxsIHdpdGgNCiAgICBwbGVudHkgb2YgVE9ETyBub3RlcyBhbmQgcXVlc3Rpb25zLiAgSSB3 aWxsIHRhbGsgYWJvdXQgdGhpcyBpZGVhIGF0DQogICAgUEdDb24sIHNvIEkgZmlndXJlZCBpdCdk IGhlbHAgdG8gaGF2ZSBhIHBhdGNoIHRoYXQgYWN0dWFsbHkgYXBwbGllcywNCiAgICBldmVuIGlm IGl0IGRvZXNuJ3Qgd29yayBxdWl0ZSByaWdodCB5ZXQuICBJdCdzIHF1aXRlIGEgbGFyZ2UgcGF0 Y2ggYnV0DQogICAgdGhhdCdzIHBhcnRseSBiZWNhdXNlIGl0IHJlbW92ZXMgYSBsb3Qgb2YgbGlu ZXMuLi4NCg0K