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 1qYoys-002ojl-Pn for pgsql-committers@arkaria.postgresql.org; Wed, 23 Aug 2023 14:37:10 +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 1qYoyr-00DVv2-Gt for pgsql-committers@arkaria.postgresql.org; Wed, 23 Aug 2023 14:37:09 +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-00DVus-9D 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-000XTa-9X for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:07 +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-0006go-UU 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-000Udt-UH for pgsql-committers@lists.postgresql.org; Wed, 23 Aug 2023 14:37:03 +0000 Content-Type: multipart/mixed; boundary="===============0336546643441027133==" 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 --===============0336546643441027133== 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 MGE5QGlraS5maQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2NjYWRmNzMxNjNjYTg4YmRhYTc0Yjgy MjNkNGRkZTA1ZDE3ZjU1MGIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIv Ymxvb20vYmxpbnNlcnQuYyAgICAgICAgICAgICAgfCAyOSArKy0tLS0tLS0tLS0tLQpjb250cmli L2Jsb29tL2Jsb29tLmggICAgICAgICAgICAgICAgIHwgIDIgKy0KY29udHJpYi9ibG9vbS9ibHV0 aWxzLmMgICAgICAgICAgICAgICB8ICA4ICsrLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9u YnRyZWUuYyAgICB8IDQxICsrKysrKysrKystLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9z cGdpc3Qvc3BnaW5zZXJ0LmMgfCA3MSArKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tLS0t LQo1IGZpbGVzIGNoYW5nZWQsIDYyIGluc2VydGlvbnMoKyksIDg5IGRlbGV0aW9ucygtKQoK --===============0336546643441027133==--