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 1oSX8d-0007OT-6G for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 05:16:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oSX7c-0008Jp-Lw for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 05:15:40 +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 1oSX7c-0008Jg-3R for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 05:15:40 +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 1oSX7Z-0000Gs-8m for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 05:15:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=qZrqVrRVjtDDJ9GQNFajT71PzxBiWJMa+rRXe92Q4R4=; b=7RB2BaC9v14f4TUHV/U7c4rbXj QmV4QxicklEipk8MzY1fCyqtxSO9I+ryrQXnWOTq3NhDggUmeGexDw9H/8JgXmGMMYmXlTExlEzVW 0XmHVSKifO/qyP3vaf6xFwv0CN+c7zU4xAvH4eIjlj2WZGKJcNo7V/kiE81k/F1cHFEKW53fZWEUZ LDF/9PWCoU6sjyHzb7mUIRCeqzpLIrfmG2fVSUkas9vITJ9i318IpCup7Xz9Nuoly8AzVEzoGeRTJ 8PvsTcm75WSm1T//4neWssyVmedGqQxc2PL80lJpxdlygWDaIllTuId+rhlBsOGxFGka6a3Q3Ft7h 76flk77g==; 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 1oSX7Y-0005ns-19 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 05:15:36 +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 1oSX7W-000PWW-RG for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 05:15:35 +0000 Content-Type: multipart/mixed; boundary="===============1985780147233606067==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve performance of and reduce overheads of memory management X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Aug 2022 05:15:35 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1985780147233606067== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwZXJmb3JtYW5jZSBvZiBhbmQgcmVkdWNlIG92ZXJoZWFkcyBvZiBtZW1vcnkgbWFu YWdlbWVudAoKV2hlbmV2ZXIgd2UgcGFsbG9jIGEgY2h1bmsgb2YgbWVtb3J5LCB0cmFkaXRpb25h bGx5LCB3ZSBwcmVmaXggdGhlCnJldHVybmVkIHBvaW50ZXIgd2l0aCBhIHBvaW50ZXIgdG8gdGhl IG1lbW9yeSBjb250ZXh0IHRvIHdoaWNoIHRoZSBjaHVuawpiZWxvbmdzLiAgVGhpcyBpcyByZXF1 aXJlZCBzbyB0aGF0IHdlJ3JlIGFibGUgdG8gZWFzaWx5IGRldGVybWluZSB0aGUKb3duaW5nIGNv bnRleHQgd2hlbiBwZXJmb3JtaW5nIG9wZXJhdGlvbnMgc3VjaCBhcyBwZnJlZSgpIGFuZCByZXBh bGxvYygpLgoKRm9yIHRoZSBBbGxvY1NldCBjb250ZXh0LCBwcmlvciB0byB0aGlzIGNvbW1pdCB3 ZSBhZGRpdGlvbmFsbHkgcHJlZml4ZWQKdGhlIHBvaW50ZXIgdG8gdGhlIG93bmluZyBjb250ZXh0 IHdpdGggdGhlIHNpemUgb2YgdGhlIGNodW5rLiAgVGhpcyBtYWRlCnRoZSBoZWFkZXIgMTYgYnl0 ZXMgaW4gc2l6ZS4gIFRoaXMgMTYtYnl0ZSBvdmVyaGVhZCB3YXMgcmVxdWlyZWQgZm9yIGFsbApB bGxvY1NldCBhbGxvY2F0aW9ucyByZWdhcmRsZXNzIG9mIHRoZSBhbGxvY2F0aW9uIHNpemUuCgpG b3IgdGhlIGdlbmVyYXRpb24gY29udGV4dCwgdGhlIHByb2JsZW0gd2FzIHdvcnNlOyBpbiBhZGRp dGlvbiB0byB0aGUKcG9pbnRlciB0byB0aGUgb3duaW5nIGNvbnRleHQgYW5kIGNodW5rIHNpemUs IHdlIGFsc28gc3RvcmVkIGEgcG9pbnRlciB0bwp0aGUgb3duaW5nIGJsb2NrIHNvIHRoYXQgd2Ug Y291bGQgdHJhY2sgdGhlIG51bWJlciBvZiBmcmVlZCBjaHVua3Mgb24gYQpibG9jay4KClRoZSBz bGFiIGFsbG9jYXRvciBoYWQgYSAxNi1ieXRlIGNodW5rIGhlYWRlci4KClRoZSBjaGFuZ2VzIGJl aW5nIG1hZGUgaGVyZSByZWR1Y2UgdGhlIGNodW5rIGhlYWRlciBzaXplIGRvd24gdG8ganVzdCA4 CmJ5dGVzIGZvciBhbGwgMyBvZiBvdXIgbWVtb3J5IGNvbnRleHQgdHlwZXMuICBGb3Igc21hbGwg dG8gbWVkaXVtIHNpemVkCmFsbG9jYXRpb25zLCB0aGlzIHNpZ25pZmljYW50bHkgaW5jcmVhc2Vz IHRoZSBudW1iZXIgb2YgY2h1bmtzIHRoYXQgd2UgY2FuCmZpdCBvbiBhIGdpdmVuIGJsb2NrIHdo aWNoIHJlc3VsdHMgaW4gbXVjaCBtb3JlIGVmZmljaWVudCB1c2Ugb2YgbWVtb3J5LgoKQWRkaXRp b25hbGx5LCB0aGlzIGNvbW1pdCBjb21wbGV0ZWx5IGNoYW5nZXMgdGhlIHJ1bGUgdGhhdCBwb2lu dGVycyB0bwpwYWxsb2MnZCBtZW1vcnkgbXVzdCBiZSBkaXJlY3RseSBwcmVmaXhlZCBieSBhIHBv aW50ZXIgdG8gdGhlIG93bmluZwptZW1vcnkgY29udGV4dCBhbmQgaW5zdGVhZCwgd2Ugbm93IGlu c2lzdCB0aGF0IHRoZXkncmUgZGlyZWN0bHkgcHJlZml4ZWQKYnkgYW4gOC1ieXRlIHZhbHVlIHdo ZXJlIHRoZSBsZWFzdCBzaWduaWZpY2FudCAzLWJpdHMgYXJlIHNldCB0byBhIHZhbHVlCnRvIGlu ZGljYXRlIHdoaWNoIHR5cGUgb2YgbWVtb3J5IGNvbnRleHQgdGhlIHBvaW50ZXIgYmVsb25ncyB0 by4gIFVzaW5nCnRob3NlIDMgYml0cyBhcyBhbiBpbmRleCAoa25vd24gYXMgTWVtb3J5Q29udGV4 dE1ldGhvZElEKSB0byBhIG5ldyBhcnJheQp3aGljaCBzdG9yZXMgdGhlIG1ldGhvZHMgZm9yIGVh Y2ggbWVtb3J5IGNvbnRleHQgdHlwZSwgd2UncmUgbm93IGFibGUgdG8KcGFzcyB0aGUgcG9pbnRl ciBnaXZlbiB0byBmdW5jdGlvbnMgc3VjaCBhcyBwZnJlZSgpIGFuZCByZXBhbGxvYygpIHRvIHRo ZQpmdW5jdGlvbiBzcGVjaWZpYyB0byB0aGF0IGNvbnRleHQgaW1wbGVtZW50YXRpb24gdG8gYWxs b3cgdGhlbSB0byBkZXZpc2UKdGhlaXIgb3duIG1ldGhvZHMgb2YgZmluZGluZyB0aGUgbWVtb3J5 IGNvbnRleHQgd2hpY2ggb3ducyB0aGUgZ2l2ZW4KYWxsb2NhdGVkIGNodW5rIG9mIG1lbW9yeS4K ClRoZSByZWFzb24gd2UncmUgYWJsZSB0byByZWR1Y2UgdGhlIGNodW5rIGhlYWRlciBkb3duIHRv IGp1c3QgOCBieXRlcyBpcwpiZWNhdXNlIG9mIHRoZSB3YXkgd2UgbWFrZSB1c2Ugb2YgdGhlIHJl bWFpbmluZyA2MSBiaXRzIG9mIHRoZSByZXF1aXJlZAo4LWJ5dGUgY2h1bmsgaGVhZGVyLiAgSGVy ZSB3ZSBhbHNvIGltcGxlbWVudCBhIGdlbmVyYWwtcHVycG9zZSBNZW1vcnlDaHVuawpzdHJ1Y3Qg d2hpY2ggbWFrZXMgdXNlIG9mIHRob3NlIDYxIHJlbWFpbmluZyBiaXRzIHRvIGFsbG93IHRoZSBz dG9yYWdlIG9mCmEgMzAtYml0IHZhbHVlIHdoaWNoIHRoZSBNZW1vcnlDb250ZXh0IGlzIGZyZWUg dG8gdXNlIGFzIGl0IHBsZWFzZXMsIGFuZAphbHNvIHRoZSBudW1iZXIgb2YgYnl0ZXMgd2hpY2gg bXVzdCBiZSBzdWJ0cmFjdGVkIGZyb20gdGhlIGNodW5rIHRvIGdldCBhCnJlZmVyZW5jZSB0byB0 aGUgYmxvY2sgdGhhdCB0aGUgY2h1bmsgaXMgc3RvcmVkIG9uIChhbHNvIDMwIGJpdHMpLiAgVGhl IDEKYWRkaXRpb25hbCByZW1haW5pbmcgYml0IGlzIHRvIGRlbm90ZSBpZiB0aGUgY2h1bmsgaXMg YW4gImV4dGVybmFsIiBjaHVuawpvciBub3QuICBFeHRlcm5hbCBoZXJlIG1lYW5zIHRoYXQgdGhl IGNodW5rIGhlYWRlciBkb2VzIG5vdCBzdG9yZSB0aGUKMzAtYml0IHZhbHVlIG9yIHRoZSBibG9j ayBvZmZzZXQuICBUaGUgTWVtb3J5Q29udGV4dCBjYW4gdXNlIHRoZXNlCmV4dGVybmFsIGNodW5r cyBhdCBhbnkgdGltZSwgYnV0IG11c3QgdXNlIHRoZW0gaWYgYW55IG9mIHRoZSB0d28gMzAtYml0 CmZpZWxkcyBhcmUgbm90IGxhcmdlIGVub3VnaCBmb3IgdGhlIHZhbHVlKHMpIHRoYXQgbmVlZCB0 byBiZSBzdG9yZWQgaW4KdGhlbS4gIFdoZW4gdGhlIGNodW5rIGlzIG1hcmtlZCBhcyBleHRlcm5h bCwgaXQgaXMgdXAgdG8gdGhlIE1lbW9yeUNvbnRleHQKdG8gZGV2aXNlIGl0cyBvd24gbWVhbnMg dG8gZGV0ZXJtaW5lIHRoZSBibG9jayBvZmZzZXQuCgpVc2luZyAzLWJpdHMgZm9yIHRoZSBNZW1v cnlDb250ZXh0TWV0aG9kSUQgZG9lcyBtZWFuIHdlJ3JlIGxpbWl0aW5nCm91cnNlbHZlcyB0byBv bmx5IGhhdmluZyBhIG1heGltdW0gb2YgOCBkaWZmZXJlbnQgbWVtb3J5IGNvbnRleHQgdHlwZXMu CldlIGNvdWxkIHJlZHVjZSB0aGUgYml0IHNwYWNlIGZvciB0aGUgMzAtYml0IHZhbHVlIGEgbGl0 dGxlIHRvIG1ha2Ugd2F5CmZvciBtb3JlIHRoYW4gMyBiaXRzLCBidXQgaXQgc2VlbXMgbGlrZSBp dCBtaWdodCBiZSBiZXR0ZXIgdG8gZG8gdGhhdCBvbmx5CmlmIHdlIGV2ZXIgbmVlZCBtb3JlIHRo YW4gOCBjb250ZXh0IHR5cGVzLiAgVGhpcyB3b3VsZCBvbmx5IGJlIGEgcHJvYmxlbQppZiBzb21l IGZ1dHVyZSBtZW1vcnkgY29udGV4dCB0eXBlIHdoaWNoIGRvZXMgbm90IHVzZSBNZW1vcnlDaHVu ayByZWFsbHkKY291bGRuJ3QgZ2l2ZSB1cCBhbnkgb2YgdGhlIDYxIHJlbWFpbmluZyBiaXRzIGlu IHRoZSBjaHVuayBoZWFkZXIuCgpXaXRoIHRoaXMgTWVtb3J5Q2h1bmssIGVhY2ggb2Ygb3VyIDMg bWVtb3J5IGNvbnRleHQgdHlwZXMgY2FuIHF1aWNrbHkKb2J0YWluIGEgcmVmZXJlbmNlIHRvIHRo ZSBibG9jayBhbnkgZ2l2ZW4gY2h1bmsgaXMgbG9jYXRlZCBvbi4gIEFsbG9jU2V0CmlzIGFibGUg dG8gZmluZCB0aGUgY29udGV4dCB0byB3aGljaCB0aGUgY2h1bmsgaXMgb3duZWQsIGJ5IGZpcnN0 Cm9idGFpbmluZyBhIHJlZmVyZW5jZSB0byB0aGUgYmxvY2sgYnkgc3VidHJhY3RpbmcgdGhlIGJs b2NrIG9mZnNldCBhcyBpcwpzdG9yZWQgaW4gdGhlICdoZHJtYXNrJyBmaWVsZCBhbmQgdGhlbiBy ZWZlcmVuY2luZyB0aGUgYmxvY2sncyAnYXNldCcKZmllbGQuICBUaGUgR2VuZXJhdGlvbiBjb250 ZXh0IHVzZXMgdGhlIHNhbWUgbWV0aG9kLCBidXQgR2VuZXJhdGlvbkJsb2NrCmRpZCBub3QgaGF2 ZSBhIGZpZWxkIHBvaW50aW5nIGJhY2sgdG8gdGhlIG93bmluZyBjb250ZXh0LCBzbyBvbmUgaXMg YWRkZWQKYnkgdGhpcyBjb21taXQuCgpJbiBhc2V0LmMgYW5kIGdlbmVyYXRpb24uYywgYWxsIGFs bG9jYXRpb25zIGxhcmdlciB0aGFuIGFsbG9jQ2h1bmtMaW1pdAphcmUgc3RvcmVkIG9uIGRlZGlj YXRlZCBibG9ja3MuICBXaGVuIHRoZXJlJ3MganVzdCBhIHNpbmdsZSBjaHVuayBvbiBhCmJsb2Nr IGxpa2UgdGhpcywgaXQncyBlYXN5IHRvIGZpbmQgdGhlIGJsb2NrIGZyb20gdGhlIGNodW5rLCB3 ZSBqdXN0CnN1YnRyYWN0IHRoZSBzaXplIG9mIHRoZSBibG9jayBoZWFkZXIgZnJvbSB0aGUgY2h1 bmsgcG9pbnRlci4gIFRoZSBzaXplIG9mCnRoZXNlIGNodW5rcyBpcyBhbHNvIGtub3duIGFzIHdl IHN0b3JlIHRoZSBlbmRwdHIgb24gdGhlIGJsb2NrLCBzbyB3ZSBjYW4KanVzdCBzdWJ0cmFjdCB0 aGUgcG9pbnRlciB0byB0aGUgYWxsb2NhdGVkIG1lbW9yeSBmcm9tIHRoYXQuICBCZWNhdXNlIHdl CmNhbiBlYXNpbHkgZmluZCB0aGUgb3duaW5nIGJsb2NrIGFuZCB0aGUgc2l6ZSBvZiB0aGUgY2h1 bmsgZm9yIHRoZXNlCmRlZGljYXRlZCBibG9ja3MsIHdlIGp1c3QgYWx3YXlzIHVzZSBleHRlcm5h bCBjaHVua3MgZm9yIGFsbG9jYXRpb24gc2l6ZXMKbGFyZ2VyIHRoYW4gYWxsb2NDaHVua0xpbWl0 LiAgRm9yIGdlbmVyYXRpb24uYywgdGhpcyBzaWRlc3RlcHMgdGhlIHByb2JsZW0Kb2Ygbm9uLWV4 dGVybmFsIE1lbW9yeUNodW5rcyBiZWluZyB1bmFibGUgdG8gcmVwcmVzZW50IGNodW5rIHNpemVz ID49IDFHQi4KVGhpcyBpcyBsZXNzIG9mIGEgcHJvYmxlbSBmb3IgYXNldC5jIGFzIHdlIHN0b3Jl IHRoZSBmcmVlIGxpc3QgaW5kZXggaW4KdGhlIE1lbW9yeUNodW5rJ3Mgc3BhcmUgMzAtYml0IGZp ZWxkICh0aGUgdmFsdWUgb2Ygd2hpY2ggd2lsbCBuZXZlciBiZQpjbG9zZSB0byB1c2luZyBhbGwg MzAtYml0cykuICBXZSBjYW4gZWFzaWx5IHJldmVyc2UgZW5naW5lZXIgdGhlIGNodW5rIHNpemUK ZnJvbSB0aGlzIHdoZW4gbmVlZGVkLiAgU3RvcmluZyB0aGlzIHNhdmVzIEFsbG9jU2V0RnJlZSgp IGZyb20gaGF2aW5nIHRvCm1ha2UgYSBjYWxsIHRvIEFsbG9jU2V0RnJlZUluZGV4KCkgdG8gZGV0 ZXJtaW5lIHdoaWNoIGZyZWUgbGlzdCB0byBwdXQgdGhlCm5ld2x5IGZyZWVkIGNodW5rIG9uLgoK Rm9yIHRoZSBzbGFiIGFsbG9jYXRvciwgdGhpcyBjb21taXQgYWRkcyBhIG5ldyByZXN0cmljdGlv biB0aGF0IHNsYWIKY2h1bmtzIGNhbm5vdCBiZSA+PSAxR0IgaW4gc2l6ZS4gIElmIHRoZXJlIGhh cHBlbmVkIHRvIGJlIGFueSB1c2VycyBvZgpzbGFiLmMgd2hpY2ggdXNlZCBjaHVuayBzaXplcyB0 aGlzIGxhcmdlLCB0aGV5IHJlYWxseSBzaG91bGQgYmUgdXNpbmcKQWxsb2NTZXQgaW5zdGVhZC4K CkhlcmUgd2UgYWxzbyBhZGQgYSByZXN0cmljdGlvbiB0aGF0IG5vcm1hbCBub24tZGVkaWNhdGVk IGJsb2NrcyBjYW5ub3QgYmUKMUdCIG9yIGxhcmdlci4gIEl0J3Mgbm93IG5vdCBwb3NzaWJsZSB0 byBwYXNzIGEgJ21heEJsb2NrU2l6ZScgPj0gMUdCCmR1cmluZyB0aGUgY3JlYXRpb24gb2YgYW4g QWxsb2NTZXQgb3IgR2VuZXJhdGlvbiBjb250ZXh0LiAgQWxsb2NhdGlvbnMgY2FuCnN0aWxsIGJl IGxhcmdlciB0aGFuIDFHQiwgaXQncyBqdXN0IHRoZXNlIHdpbGwgYWx3YXlzIGJlIG9uIGRlZGlj YXRlZApibG9ja3MgKHdoaWNoIGRvIG5vdCBoYXZlIHRoZSAxR0IgcmVzdHJpY3Rpb24pLgoKQXV0 aG9yOiBBbmRyZXMgRnJldW5kLCBEYXZpZCBSb3dsZXkKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9DQUFwSER2cGphdUNSWGNnY2FMNitlM2VxZWNFSG9lUm05RC1rY2J1dkJpdGdQblc9 dndAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9jNmUwZmUxZjJhMDg1MDU1 NDRjNDEwZjYxMzgzOTY2NGVlYTllYjIxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC91dGlscy9tbWdyL1JFQURNRSAgICAgICAgICAgIHwgIDYwICsrLS0Kc3JjL2Jh Y2tlbmQvdXRpbHMvbW1nci9hc2V0LmMgICAgICAgICAgICB8IDUzMyArKysrKysrKysrKysrKysr Ky0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL21tZ3IvZ2VuZXJhdGlvbi5jICAgICAg fCAzNjAgKysrKysrKysrKystLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL21tZ3IvbWN4dC5j ICAgICAgICAgICAgfCAgOTMgKysrKystCnNyYy9iYWNrZW5kL3V0aWxzL21tZ3Ivc2xhYi5jICAg ICAgICAgICAgfCAyMDAgKysrKystLS0tLS0tCnNyYy9pbmNsdWRlL25vZGVzL21lbW5vZGVzLmgg ICAgICAgICAgICAgfCAgIDcgKy0Kc3JjL2luY2x1ZGUvdXRpbHMvbWVtdXRpbHMuaCAgICAgICAg ICAgICB8ICA1MSArLS0Kc3JjL2luY2x1ZGUvdXRpbHMvbWVtdXRpbHNfaW50ZXJuYWwuaCAgICB8 IDEyNyArKysrKysrKwpzcmMvaW5jbHVkZS91dGlscy9tZW11dGlsc19tZW1vcnljaHVuay5oIHwg MjM3ICsrKysrKysrKysrKysrCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAgICAg ICAgfCAgIDYgKy0KMTAgZmlsZXMgY2hhbmdlZCwgMTA1NiBpbnNlcnRpb25zKCspLCA2MTggZGVs ZXRpb25zKC0pCgo= --===============1985780147233606067==--