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 1sPbrV-005R6A-Gw for pgsql-committers@arkaria.postgresql.org; Fri, 05 Jul 2024 05:52: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 1sPbrT-006hKT-Af for pgsql-committers@arkaria.postgresql.org; Fri, 05 Jul 2024 05:52: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 1sPbrS-006hKK-Up for pgsql-committers@lists.postgresql.org; Fri, 05 Jul 2024 05:51:59 +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 1sPbrQ-000U1l-Vk for pgsql-committers@lists.postgresql.org; Fri, 05 Jul 2024 05:51:58 +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=js+WyiTPqxbV1wMxn6ir4AIvji/PXchJqa508gXKwwU=; b=aRQG910RAPLlvU4K9mzvRbuI5k IB63MjKa2JPmw5i57KJh7AYG1V2zetqXJQ/5rEOjVx/7CNBs5xQ1kgRb/w9mDC7u2PbBBLJO8wHqT f35wILZpjSnWeEzW1doJqDR+NrR3M2XcFDt/KwIGLdH096EESbRvN8wfFFlShDkR7kaFFnbg6rZLC 8yeoMDugF0jXQzwMphgc796sv8U47xN7NYnvWMsOoAU0PGHNd6u0MGjGr+puhiw7YU/jpsW6VyxUI 69dgTO0uUgnGu+OuMBnTuJYUvzTrCMSgFWvKIA62xbWGLkZmEg/WnxsllGNwwAcOoOX43xjG7kshZ X3Chc/XA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sPbrQ-001TuX-4D for pgsql-committers@lists.postgresql.org; Fri, 05 Jul 2024 05:51:56 +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 1sPbrO-000NaK-6T for pgsql-committers@lists.postgresql.org; Fri, 05 Jul 2024 05:51:55 +0000 Content-Type: multipart/mixed; boundary="===============8288780629312374507==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve memory management and performance of tuplestore.c X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 05 Jul 2024 05:51:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8288780629312374507== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBtZW1vcnkgbWFuYWdlbWVudCBhbmQgcGVyZm9ybWFuY2Ugb2YgdHVwbGVzdG9yZS5j CgpIZXJlIHdlIG1ha2UgdHVwbGVzdG9yZS5jIHVzZSBhIGdlbmVyYXRpb24uYyBtZW1vcnkgY29u dGV4dCByYXRoZXIgdGhhbgphbGxvY2F0aW5nIHR1cGxlcyBpbnRvIHRoZSBDdXJyZW50TWVtb3J5 Q29udGV4dCwgd2hpY2ggcHJpbWFyaWx5IGlzIHRoZQpFeGVjdXRvclN0YXRlIG9yIFBvcnRhbEhv bGRDb250ZXh0IG1lbW9yeSBjb250ZXh0LiAgTm90IGhhdmluZyBhCmRlZGljYXRlZCBjb250ZXh0 IGNhbiBjYXVzZSB0aGUgQ3VycmVudE1lbW9yeUNvbnRleHQgY29udGV4dCB0byBiZWNvbWUKYmxv YXRlZCB3aGVuIHBmcmVlJ2QgY2h1bmtzIGFyZSBub3QgcmV1c2VkIGJ5IGZ1dHVyZSB0dXBsZXMu ICBVc2luZwpnZW5lcmF0aW9uIHNwZWVkcyB1cCB1c2VycyBvZiB0dXBsZXN0b3JlLmMsIHN1Y2gg YXMgdGhlIE1hdGVyaWFsaXplLApXaW5kb3dBZ2cgYW5kIENURSBTY2FuIGV4ZWN1dG9yIG5vZGVz LiAgVGhlIG1haW4gcmVhc29uIGZvciB0aGUgc3BlZWR1cCBpcwpkdWUgdG8gZ2VuZXJhdGlvbi5j IGJlaW5nIG1vcmUgbWVtb3J5IGVmZmljaWVudCB0aGFuIGFzZXQuYyBtZW1vcnkKY29udGV4dHMu ICBTcGVjaWZpY2FsbHksIGdlbmVyYXRpb24gZG9lcyBub3Qgcm91bmQgc2l6ZXMgdXAgdG8gdGhl IG5leHQKcG93ZXIgb2YgMiB2YWx1ZS4gIFRoaXMgYm90aCBzYXZlcyBtZW1vcnksIGFsbG93aW5n IG1vcmUgdHVwbGVzIHRvIGZpdCBpbgp3b3JrX21lbSwgYnV0IGFsc28gbWFrZXMgdGhlIG1lbW9y eSB1c2FnZSBtb3JlIGNvbXBhY3QgYW5kIGZpdCBvbiBmZXdlcgpjYWNoZWxpbmVzLiAgT25lIGJl bmNobWFyayBzaG93ZWQgdXAgdG8gYSAyMiUgcGVyZm9ybWFuY2UgaW5jcmVhc2UgaW4gYQpxdWVy eSBjb250YWluaW5nIGEgTWF0ZXJpYWxpemUgbm9kZS4gIE11Y2ggaGlnaGVyIGdhaW5zIGFyZSBw b3NzaWJsZSBpZgp0aGUgbWVtb3J5IHJlZHVjdGlvbiBwcmV2ZW50cyB0dXBsZXN0b3JlLmMgZnJv bSBzcGlsbGluZyB0byBkaXNrLiAgVGhpcyBpcwplc3BlY2lhbGx5IHRydWUgZm9yIFdpbmRvd0Fn ZyBub2RlcyB3aGVyZSBpbXByb3ZlbWVudHMgb2Ygc2V2ZXJhbCB0aG91c2FuZAp0aW1lcyBhcmUg cG9zc2libGUgaWYgdGhlIG1lbW9yeSByZWR1Y3Rpb25zIG1hZGUgaGVyZSBwcmV2ZW50IHR1cGxl c3RvcmUKZnJvbSBzcGlsbGluZyB0byBkaXNrLgoKQWRkaXRpb25hbGx5LCBhIGdlbmVyYXRpb24u YyBtZW1vcnkgY29udGV4dCBpcyBtdWNoIGJldHRlciBzdWl0ZWQgZm9yIHRoaXMKam9iIGFzIGl0 IHdvcmtzIHdlbGwgd2l0aCBGSUZPIHBhbGxvYy9wZnJlZSBwYXR0ZXJucywgd2hpY2ggaXMgZXhh Y3RseSBob3cKdHVwbGVzdG9yZS5jIHVzZXMgaXQuICBCZWNhdXNlIG9mIHRoZSB3YXkgZ2VuZXJh dGlvbi5jIGFsbG9jYXRlcyBtZW1vcnksCnR1cGxlcyBjb25zZWN1dGl2ZWx5IHN0b3JlZCBpbiB0 dXBsZXN0b3JlcyBhcmUgbXVjaCBtb3JlIGxpa2VseSB0byBiZQpzdG9yZWQgY29uc2VjdXRpdmVs eSBpbiBtZW1vcnkuICBUaGlzIGFsbG93cyB0aGUgQ1BVJ3MgaGFyZHdhcmUgcHJlZmV0Y2hlcgp0 byB3b3JrIG1vcmUgZWZmaWNpZW50bHkgYXMgaXQgcHJvdmlkZXMgYSBtb3JlIHByZWRpY3RhYmxl IHBhdHRlcm4gdG8KYWxsb3cgY2FjaGVsaW5lcyBmb3IgdGhlIG5leHQgdHVwbGUgdG8gYmUgbG9h ZGVkIGZyb20gUkFNIGluIGFkdmFuY2Ugb2YKdGhlbSBiZWluZyBuZWVkZWQgYnkgdGhlIGV4ZWN1 dG9yLgoKVXNpbmcgYSBkZWRpY2F0ZWQgbWVtb3J5IGNvbnRleHQgZm9yIHN0b3JpbmcgdHVwbGVz IGFsc28gYWxsb3dzIHVzIHRvIG1vcmUKZWZmaWNpZW50bHkgY2xlYW4gdXAgdGhlIG1lbW9yeSB1 c2VkIGJ5IHRoZSB0dXBsZXN0b3JlIGFzIHdlIGNhbiByZXNldCBvcgpkZWxldGUgdGhlIGNvbnRl eHQgcmF0aGVyIHRoYW4gbG9vcGluZyBvdmVyIGFsbCBzdG9yZWQgdHVwbGVzIGFuZApwZnJlZSdp bmcgdGhlbSBvbmUgYnkgb25lLgoKQWxzbywgcmVtb3ZlIGEgYmFkbHkgcGxhY2VkIFVTRU1FTSBj YWxsIGluIHJlYWR0dXBfaGVhcCgpLiAgVGhlIHR1cGxlCndhc24ndCBiZWluZyBhbGxvY2F0ZWQg aW4gdGhlIFR1cGxlc3RvcmVzdGF0ZSdzIGNvbnRleHQsIHNvIG5vIG5lZWQgdG8KYWRqdXN0IHRo ZSBtZW1vcnkgY29uc3VtZWQgYnkgdGhlIHR1cGxlc3RvcmUgdGhlcmUuCgpBdXRob3I6IERhdmlk IFJvd2xleQpSZXZpZXdlZC1ieTogTWF0dGhpYXMgdmFuIGRlIE1lZW50LCBEbWl0cnkgRG9sZ292 CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FBcEhEdnA1UHk5ZzRSanE3X2luTDMt TUNLMUNvMkNSdF9ZV0Z3VFUyemZRaXgwcDRBQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0t Cm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2Nv bW1pdGRpZmYvNTkwYjA0NWMzN2FhZDQ0OTE1ZjdmNDcyMzQzZjI0YzJiYWZiZTVkOAoKTW9kaWZp ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvc29ydC90dXBsZXN0b3Jl LmMgfCA1NSArKysrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0tCjEgZmlsZSBjaGFu Z2VkLCA0MCBpbnNlcnRpb25zKCspLCAxNSBkZWxldGlvbnMoLSkKCg== --===============8288780629312374507==--