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 1sYGGL-00A54b-Oj for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 02:37:25 +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 1sYGGK-00EDtj-88 for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 02:37:24 +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 1sYGGJ-00EDhV-OO for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 02:37:23 +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 1sYGGG-001xfd-U9 for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 02:37:22 +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=IM6tuA9aLeeyCjhE8NCxyAmg+E+0fVCzCjr6DkR7Ibk=; b=5XR7l4aDq/RVNleSwItO/cxrEb fSgEpnFSQwqIV2vpcutHdEg9LlfsIuKr258Stkw/vJC3tLTt3QIfUfPSV0X1lGeWjJ6Hyub0v0mOp 2o2ZGDCw6a1gmRq3JSzdGg7vZ8yS6oQGC1YheJNEZ3ytHjZyzC4eVTXiPG13gVmD9FcUJtpCkLnB/ DweNOGvP3F9ENpjOZd4zbCZBXxdk0maJKHulv0cpBufxms8b9p6tgyH8GoYZ1hkRbwyLBfV+nR0EU 9dwGyjEE5wnrFlLb0amXayHw6XiABQiQCO2QRXK317xnygsyJct2uyK6w+iU/DTfdr/xMd7qg5fl0 8Y2Wgssg==; 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 1sYGGG-006BAc-4h for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 02:37:20 +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 1sYGGF-001gjW-5U for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 02:37:19 +0000 Content-Type: multipart/mixed; boundary="===============2262794637837286999==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Reduce memory used by partitionwise joins X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Jul 2024 02:37:19 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2262794637837286999== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVkdWNlIG1lbW9yeSB1c2VkIGJ5IHBhcnRpdGlvbndpc2Ugam9pbnMKCkluIHRyeV9wYXJ0aXRp b253aXNlX2pvaW4sIHdlIGFpbSB0byBicmVhayBkb3duIHRoZSBqb2luIGJldHdlZW4gdHdvCnBh cnRpdGlvbmVkIHJlbGF0aW9ucyBpbnRvIGpvaW5zIGJldHdlZW4gbWF0Y2hpbmcgcGFydGl0aW9u cy4gIFRvCmFjaGlldmUgdGhpcywgd2UgaXRlcmF0ZSB0aHJvdWdoIGVhY2ggcGFpciBvZiBwYXJ0 aXRpb25zIGZyb20gdGhlIHR3bwpqb2luaW5nIHJlbGF0aW9ucyBhbmQgY3JlYXRlIGNoaWxkLWpv aW4gcmVsYXRpb25zIGZvciB0aGVtLiAgV2l0aApwb3RlbnRpYWxseSB0aG91c2FuZHMgb2YgcGFy dGl0aW9ucywgdGhlIGxvY2FsIG9iamVjdHMgYWxsb2NhdGVkIGluCmVhY2ggaXRlcmF0aW9uIGNh biBhY2N1bXVsYXRlIHNpZ25pZmljYW50IG1lbW9yeSB1c2FnZS4gIFRoZXJlZm9yZSwgd2UKb3B0 IHRvIGVhZ2VybHkgZnJlZSB0aGVzZSBsb2NhbCBvYmplY3RzIGF0IHRoZSBlbmQgb2YgZWFjaCBp dGVyYXRpb24uCgpJbiBsaW5lIHdpdGggdGhpcyBhcHByb2FjaCwgdGhpcyBwYXRjaCBmcmVlcyB0 aGUgYml0bWFwIHNldCB0aGF0CnJlcHJlc2VudHMgdGhlIHJlbGlkcyBvZiBjaGlsZC1qb2luIHJl bGF0aW9ucyBhdCB0aGUgZW5kIG9mIGVhY2gKaXRlcmF0aW9uLiAgQWRkaXRpb25hbGx5LCBpdCBt b2RpZmllcyBidWlsZF9jaGlsZF9qb2luX3JlbCgpIHRvIHJldXNlCnRoZSBBcHBlbmRSZWxJbmZv IHN0cnVjdHVyZXMgZ2VuZXJhdGVkIHdpdGhpbiBlYWNoIGl0ZXJhdGlvbi4KCkF1dGhvcjogQXNo dXRvc2ggQmFwYXQKUmV2aWV3ZWQtYnk6IERhdmlkIENocmlzdGVuc2VuLCBSaWNoYXJkIEd1bwpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBRXhIVzVzNEVxWTQzb0I9bmU2QjI9LXhM Z3JzOVpHZVRyMU5Yd2tHRnQyai1PbWFRUUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQpt YXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmLzUxM2Y0NDcyYTRhMGQyOTRjYTY0MTIzNjI3Y2U3YjQ4Y2UwZWU3YzEKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2pvaW5yZWxz LmMgfCAxNSArKysrKysrKysrKy0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVsbm9k ZS5jICB8IDE4ICsrKy0tLS0tLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aG5v ZGUuaCAgICAgIHwgIDMgKystCjMgZmlsZXMgY2hhbmdlZCwgMTYgaW5zZXJ0aW9ucygrKSwgMjAg ZGVsZXRpb25zKC0pCgo= --===============2262794637837286999==--