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 1sr7jH-00FXBV-Qu for pgsql-committers@arkaria.postgresql.org; Thu, 19 Sep 2024 03:21:16 +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 1sr7jG-002g13-7m for pgsql-committers@arkaria.postgresql.org; Thu, 19 Sep 2024 03:21:14 +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 1sr7jF-002fzH-Ln for pgsql-committers@lists.postgresql.org; Thu, 19 Sep 2024 03:21:13 +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 1sr7jB-001uGh-1o for pgsql-committers@lists.postgresql.org; Thu, 19 Sep 2024 03:21:12 +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=UE4b8QPJxfXgezXJ7jgwu/TBweuvSYtRgAe/p+f1iwI=; b=tgBxdd7xSbYZpy6BH4TkGKpJ5I CHkqna2W+X1qEAC+82FfBxFA19Ss7Bf/Je4ronBPxi+wlpAo8yGRn1E+jz6bspo+8k3V2X6v6EVSM wNpLl2uQeIrJHWNZ4vpuTiTegaK1zHgfvwmvO9MfDRGklQdlMHcNrkNQAFJ/qa7WX2G3Ma08p2t9o 5Xl8cxIlqIYfSPm7IP4o4v0mY+xZDpIwRtVivNTCng0PkMCkhnblTkIhK6m2JIpEIhWS9uHVsSZzb LoqGuBxztTJdboBh7qd3CbWou59pn8p7dlbwMCzfPC6uY1AJUw0xMuylnMBprqFTO6OkeqtWBcAcP rcs9WIJA==; 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 1sr7j9-00683y-UK for pgsql-committers@lists.postgresql.org; Thu, 19 Sep 2024 03:21:07 +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 1sr7j9-001jEp-0o for pgsql-committers@lists.postgresql.org; Thu, 19 Sep 2024 03:21:07 +0000 Content-Type: multipart/mixed; boundary="===============5721545295063480292==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize tuplestore usage for WITH RECURSIVE CTEs X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 19 Sep 2024 03:21:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5721545295063480292== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgdHVwbGVzdG9yZSB1c2FnZSBmb3IgV0lUSCBSRUNVUlNJVkUgQ1RFcwoKbm9kZVJl Y3Vyc2l2ZXVuaW9uLmMgbWFrZXMgdXNlIG9mIHR3byB0dXBsZXN0b3JlcyBhbmQsIHVudGlsIG5v dywgd291bGQKZGVsZXRlIGFuZCByZWNyZWF0ZSBvbmUgb2YgdGhlc2UgdHVwbGVzdG9yZXMgYWZ0 ZXIgZXZlcnkgcmVjdXJzaXZlCml0ZXJhdGlvbi4KCkhlcmUgd2UgYWRqdXN0IHRoYXQgYmVoYXZp b3IgYW5kIGluc3RlYWQgcmV1c2Ugb25lIG9mIHRoZSBleGlzdGluZwp0dXBsZXN0b3JlcyBhbmQg anVzdCBlbXB0eSBpdCBvZiBhbGwgdHVwbGVzIHVzaW5nIHR1cGxlc3RvcmVfY2xlYXIoKS4KClRo aXMgc2F2ZXMgc29tZSBmcmVlL21hbGxvYyByb3VuZHRyaXBzIGFuZCBoYXMgc2hvd24gYSAyNS0z MCUgcGVyZm9ybWFuY2UKaW1wcm92ZW1lbnQgZm9yIHF1ZXJpZXMgdGhhdCBwZXJmb3JtIHZlcnkg bGl0dGxlIHdvcmsgYmV0d2VlbiByZWN1cnNpdmUKaXRlcmF0aW9ucy4KClRoaXMgYWxzbyBwYXZl cyB0aGUgd2F5IHRvIGFkZCBzb21lIEVYUExBSU4gQU5BTFlaRSB0ZWxlbWV0cnkgb3V0cHV0IGZv cgpyZWN1cnNpdmUgY29tbW9uIHRhYmxlIGV4cHJlc3Npb25zLCBzaW1pbGFyIHRvIHdoYXQgd2Fz IGRvbmUgaW4gMWVmZjgyNzlkCmFuZCA5NWQ2ZTlhZjAuICBQcmV2aW91c2x5IGNhbGxpbmcgdHVw bGVzdG9yZV9lbmQoKSB3b3VsZCBoYXZlIGNhdXNlZAp0aGUgbWF4aW11bSBzdG9yYWdlIHNwYWNl IHVzZWQgdG8gYmUgbG9zdC4KClJldmlld2VkLWJ5OiBUYXRzdW8gSXNoaWkKRGlzY3Vzc2lvbjog aHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUFwSER2cjl5VzBZUmlLOEEySjdudnlUOGcxN1l6YlNmT3Zp RVdyZ2hhektaYkhiaWdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81ZDU2 ZDA3Y2EzNDNhNDY3Y2U3NGEwNDJjMjJjOTYzZWEyNjkwZWFmCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlUmVjdXJzaXZldW5pb24uYyB8IDE5 ICsrKysrKysrKysrKystLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDEzIGluc2VydGlvbnMoKyksIDYg ZGVsZXRpb25zKC0pCgo= --===============5721545295063480292==--