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 1ov7Zr-0005Hf-Fd for pgsql-committers@arkaria.postgresql.org; Wed, 16 Nov 2022 01:50:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ov7Zp-0006fv-He for pgsql-committers@arkaria.postgresql.org; Wed, 16 Nov 2022 01:50:57 +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 1ov7Zp-0006fE-AO for pgsql-committers@lists.postgresql.org; Wed, 16 Nov 2022 01:50:57 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ov7Zm-0007ef-Ul for pgsql-committers@lists.postgresql.org; Wed, 16 Nov 2022 01:50:56 +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 1ov7Zl-00075h-Ja for pgsql-committers@lists.postgresql.org; Wed, 16 Nov 2022 01:50:53 +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 1ov7Zk-000O8a-9W for pgsql-committers@lists.postgresql.org; Wed, 16 Nov 2022 01:50:53 +0000 Content-Type: multipart/mixed; boundary="===============3832813398564708681==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid some overhead with open and close of catalog indexes X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 16 Nov 2022 01:50:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3832813398564708681== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgc29tZSBvdmVyaGVhZCB3aXRoIG9wZW4gYW5kIGNsb3NlIG9mIGNhdGFsb2cgaW5kZXhl cwoKVGhpcyBjb21taXQgaW1wcm92ZXMgdHdvIGNvZGUgcGF0aHMgdG8gb3BlbiBhbmQgY2xvc2Ug aW5kZXhlcyBhCm1pbmltdW0gYW1vdW50IG9mIHRpbWVzIHdoZW4gZG9pbmcgYSBzZXJpZXMgb2Yg Y2F0YWxvZyB1cGRhdGVzIG9yCmluc2VydHMuICBDYXRhbG9nVHVwbGVJbnNlcnQoKSBpcyBjb3N0 bHkgd2hlbiB1c2luZyBpdCBmb3IgbXVsdGlwbGUKaW5zZXJ0cyBvciB1cGRhdGVzIGNvbXBhcmVk IHRvIENhdGFsb2dUdXBsZUluc2VydFdpdGhJbmZvKCksIGFzIGl0IHdvdWxkCm5lZWQgdG8gb3Bl biBhbmQgY2xvc2UgdGhlIGluZGV4ZXMgb2YgdGhlIGNhdGFsb2cgd29ya2VkIGVhY2ggdGltZSBh bgpvcGVyYXRpb24gaXMgZG9uZS4KClRoaXMgY29tbWl0IHVwZGF0ZXMgdGhlIGZvbGxvd2luZyBw bGFjZXM6Ci0gUkVJTkRFWCBDT05DVVJSRU5UTFkgd2hlbiBjb3B5aW5nIHN0YXRpc3RpY3MgZnJv bSBvbmUgaW5kZXggcmVsYXRpb24KdG8gdGhlIG90aGVyLiAgTXVsdGktSU5TRVJUcyBhcmUgYXZv aWRlZCBoZXJlLCBhcyB0aGlzIHdvdWxkIGJlZ2luIHRvCnNob3cgYmVuZWZpdHMgb25seSBmb3Ig aW5kZXhlcyB3aXRoIG11bHRpcGxlIGV4cHJlc3Npb25zLCBmb3IgZXhhbXBsZSwKd2hpY2ggbWF5 IG5vdCBiZSB0aGUgbW9zdCBjb21tb24gcGF0dGVybi4gIFRoaXMgY2hhbmdlIGlzIG5vdGljZWFi bGUgaW4KcHJvZmlsZXMgd2l0aCBpbmRleGVzIGhhdmluZyBtYW55IGV4cHJlc3Npb25zLCBmb3Ig ZXhhbXBsZSwgYW5kIGl0IHdvdWxkCmltcHJvdmUgYW55IGNhbGxlcnMgb2YgQ29weVN0YXRpc3Rp Y3MoKS4KLSBVcGRhdGUgb2Ygc3RhdGlzdGljcyBvbiBBTkFMWVpFLCB0aGF0IG1peGVzIGluc2Vy dHMgYW5kIHVwZGF0ZXMuCkluIGVhY2ggY2FzZSwgdGhlIGNhdGFsb2cgaW5kZXhlcyBhcmUgb3Bl bmVkIG9ubHkgaWYgYXQgbGVhc3Qgb25lCmluc2VydGlvbiBhbmQvb3IgdXBkYXRlIGlzIHJlcXVp cmVkLCB0byBtaW5pbWl6ZSB0aGUgY29zdCBvZiB0aGUKb3BlcmF0aW9uLiAgTGlrZSB0aGUgcHJl dmlvdXMgY29kaW5nLCBubyBpbmRleGVzIGFyZSBvcGVuZWQgYXMgbG9uZyBhcwphdCBsZWFzdCBv bmUgaW5zZXJ0IG9yIHVwZGF0ZSBvZiBwZ19zdGF0aXN0aWMgaGFzIGhhcHBlbmVkLgoKQXV0aG9y OiBSYW5pZXIgVmlsZWxhClJldmlld2VkLWJ5OiBLeW90YXJvIEhvcmlndWNoaSwgTWljaGFlbCBQ YXF1aWVyCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FFdWRRQXFoMEY5eTZEaV9X Yzh4VzR6a1dtXzVTRGQtblJmVnNDbj1oME5tMUNfbXJnQG1haWwuZ21haWwuY29tCgpCcmFuY2gK LS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvMDlhNzIxODhjZDVjZGQxNzlkYzgxNGM2NzI5ZjhhMzc4NWIyM2MzNgoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMg ICAgIHwgMTAgKysrKysrKysrLQpzcmMvYmFja2VuZC9jb21tYW5kcy9hbmFseXplLmMgfCAxMSAr KysrKysrKystLQoyIGZpbGVzIGNoYW5nZWQsIDE4IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25z KC0pCgo= --===============3832813398564708681==--