Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYozh-002old-PH for pgsql-committers@arkaria.postgresql.org; Wed, 23 Aug 2023 14:38:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qYozg-00DWi3-ML for pgsql-committers@arkaria.postgresql.org; Wed, 23 Aug 2023 14:38:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYoyr-00DVut-Ju for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYoym-000XTZ-84 for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:08 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qYoyl-0006gp-RQ for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qYoyk-000Udu-Ui for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:03 +0000 Content-Type: multipart/mixed; boundary="===============4896282760949862625==" MIME-Version: 1.0 From: Heikki Linnakangas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use the buffer cache when initializing an unlogged index. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 23 Aug 2023 14:37:03 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4896282760949862625== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIHRoZSBidWZmZXIgY2FjaGUgd2hlbiBpbml0aWFsaXppbmcgYW4gdW5sb2dnZWQgaW5kZXgu CgpTb21lIG9mIHRoZSBhbWJ1aWxkZW1wdHkgZnVuY3Rpb25zIHVzZWQgc21ncndyaXRlKCkgZGly ZWN0bHksIGZvbGxvd2VkCmJ5IHNtZ3JpbW1lZHN5bmMoKS4gQSBmZXcgc21hbGwgcHJvYmxlbXMg d2l0aCB0aGF0OgoKRmlyc3RseSwgb25lIGlzIHN1cHBvc2VkIHRvIHVzZSBzbWdyZXh0ZW5kKCkg d2hlbiBleHRlbmRpbmcgYQpyZWxhdGlvbiwgbm90IHNtZ3J3cml0ZSgpLiBJdCBkb2Vzbid0IG1h a2UgbXVjaCBkaWZmZXJlbmNlIGluCnByb2R1Y3Rpb24gYnVpbGRzLiBzbWdyZXh0ZW5kKCkgdXBk YXRlcyB0aGUgcmVsYXRpb24gc2l6ZSBjYWNoZSwgc28KeW91IG1pc3MgdGhhdCwgYnV0IHRoYXQn cyBoYXJtbGVzcyBiZWNhdXNlIHdlIG5ldmVyIHVzZSB0aGUgY2FjaGVkCnJlbGF0aW9uIHNpemUg b2YgYW4gaW5pdCBmb3JrLiBCdXQgaWYgeW91IGNvbXBpbGUgd2l0aApDSEVDS19XUklURV9WU19F WFRFTkQsIHlvdSBnZXQgYW4gYXNzZXJ0aW9uIGZhaWx1cmUuCgpTZWNvbmRseSwgdGhlIHNtZ3J3 cml0ZSgpIGNhbGxzIHdlcmUgcGVyZm9ybWVkIGJlZm9yZSBXQUwtbG9nZ2luZywgc28KdGhlIHBh Z2UgaW1hZ2Ugd3JpdHRlbiB0byBkaXNrIGhhZCAwLzAgYXMgdGhlIExTTiwgbm90IHRoZSBMU04g b2YgdGhlCldBTCByZWNvcmQuIFRoYXQncyBhbHNvIGhhcm1sZXNzIGluIHByYWN0aWNlLCBidXQg c2VlbXMgc2xvcHB5LgoKVGhpcmRseSwgaXQncyBiZXR0ZXIgdG8gdXNlIHRoZSBidWZmZXIgY2Fj aGUsIGJlY2F1c2UgdGhlbiB5b3UgZG9uJ3QKbmVlZCB0byBzbWdyaW1tZWRzeW5jKCkgdGhlIHJl bGF0aW9uIHRvIGRpc2ssIHdoaWNoIGFkZHMgbGF0ZW5jeS4KQnlwYXNzaW5nIHRoZSBjYWNoZSBt YWtlcyBzZW5zZSBmb3IgYnVsayBvcGVyYXRpb25zIGxpa2UgaW5kZXgKY3JlYXRpb24sIGJ1dCBu b3Qgd2hlbiB5b3UncmUganVzdCBpbml0aWFsaXppbmcgYW4gZW1wdHkgaW5kZXguCkNyZWF0aW9u IG9mIHVubG9nZ2VkIHRhYmxlcyBpcyBoYXJkbHkgcGVyZm9ybWFuY2UgYm90dGxlbmVjayBpbiBh bnkKcmVhbCB3b3JsZCBhcHBsaWNhdGlvbnMsIGJ1dCBuZXZlcnRoZWxlc3MuCgpCYWNrcGF0Y2gg dG8gdjE2LCBidXQgbm8gZnVydGhlci4gVGhlc2UgaXNzdWVzIHNob3VsZCBiZSBoYXJtbGVzcyBp bgpwcmFjdGljZSwgc28gYmV0dGVyIHRvIG5vdCByb2NrIHRoZSBib2F0IGluIG9sZGVyIGJyYW5j aGVzLgoKUmV2aWV3ZWQtYnk6IFJvYmVydCBIYWFzCkRpc2N1c3Npb246IGh0dHBzOi8vd3d3LnBv c3RncmVzcWwub3JnL21lc3NhZ2UtaWQvNmU1YmJjMDgtY2RmYy1iMmIzLTllMjMtMWE5MTRiOTg1 MGE5QGlraS5maQoKQnJhbmNoCi0tLS0tLQpSRUxfMTZfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82YmMxZmQ0ZTYwZTk1NTZi YTVlMDQ3MTAwNDlmZGY0MmUzMTM0ZjQ3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpj b250cmliL2Jsb29tL2JsaW5zZXJ0LmMgICAgICAgICAgICAgIHwgMjkgKystLS0tLS0tLS0tLS0K Y29udHJpYi9ibG9vbS9ibG9vbS5oICAgICAgICAgICAgICAgICB8ICAyICstCmNvbnRyaWIvYmxv b20vYmx1dGlscy5jICAgICAgICAgICAgICAgfCAgOCArKy0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9u YnRyZWUvbmJ0cmVlLmMgICAgfCA0MSArKysrKysrKysrLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9h Y2Nlc3Mvc3BnaXN0L3NwZ2luc2VydC5jIHwgNzEgKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0t LS0tLS0tLS0KNSBmaWxlcyBjaGFuZ2VkLCA2MiBpbnNlcnRpb25zKCspLCA4OSBkZWxldGlvbnMo LSkKCg== --===============4896282760949862625==--