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 1ulntG-005kBI-Cz for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Aug 2025 12:14:06 +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 1ulntE-007P60-Fb for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Aug 2025 12:14:04 +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 1ulaZq-0046fl-3e for pgsql-bugs@lists.postgresql.org; Mon, 11 Aug 2025 22:01:10 +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.96) (envelope-from ) id 1ulaZk-0005NQ-27 for pgsql-bugs@lists.postgresql.org; Mon, 11 Aug 2025 22:01:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=NWfDcXqQeIXuB9NkFtIEv+c2VcAsdM4B3sP+UogGC7M=; b=ANEDDM4lFPFJ4BejIXKfz7yI7x s+0EPCZF07n1echt0E4kJLFbO/VhLl6pCbhPDJoZ6T3pObe3UhfDOk99Hnk3c8Q+IFkutePK0sKza VYdUCADpIKNzPuprWMlwY6C+/11W/HFLi3r21+XIPorDtOJM/qYForvIh4hgv9k0MyMT/+aQQyydx Sv5OHGUPkSWCtL4ulEnjXKGpb2NsBR154uBv6UZ6LqxStMwBkGATQ4iKtVFKMgPxRSW1PPje14yWh WuwzHBO3fMbDfHo1XfB3xE9I+QUgYKARGlL2ZaVvvy3LFrXftLIjuVNeu5kg01z8beLBLjhqHPJn1 U7S2ZDDg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ulaZj-000EjU-Sb for pgsql-bugs@lists.postgresql.org; Mon, 11 Aug 2025 22:01:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ulaZi-000S9f-2h for pgsql-bugs@lists.postgresql.org; Mon, 11 Aug 2025 22:01:03 +0000 Content-Type: multipart/mixed; boundary="===============4254447358249807530==" MIME-Version: 1.0 Subject: BUG #19018: high memory usage and "stack depth limit exceeded", with GiST index on ltree To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dull.bananas0@gmail.com Reply-To: dull.bananas0@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 11 Aug 2025 22:00:52 +0000 Message-ID: <19018-a5ed1ced2ec2e2ff@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4254447358249807530== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAxOApMb2dnZWQgYnk6ICAgICAgICAgIEpvc2VwaCBTaWx2YQpFbWFp bCBhZGRyZXNzOiAgICAgIGR1bGwuYmFuYW5hczBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTcuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIEZlZG9yYQpEZXNjcmlwdGlvbjogICAgICAgIAoK SWYgSSBydW4gdGhpcywgdGhlbiB0aGUgcG9zdGdyZXMgcHJvY2VzcydzIG1lbW9yeSB1c2FnZSBh cHByb2FjaGVzIDYgR0IsIGFuZAp0aGUgaW5zZXJ0aW9uIHdoZW4KaT0yNTMgZmFpbHMgd2l0aCAi c3RhY2sgZGVwdGggbGltaXQgZXhjZWVkZWQiOgoKYGBgCkNSRUFURSBFWFRFTlNJT04gbHRyZWU7 CgpDUkVBVEUgVEFCTEUgY29tbWVudCAocGF0aCBsdHJlZSk7CgpDUkVBVEUgSU5ERVggT04gY29t bWVudCBVU0lORyBnaXN0IChwYXRoKTsKCkRPICQkCiAgICBERUNMQVJFCiAgICAgICAgaSBpbnQg Oj0gMTsKICAgICAgICBwIHRleHQgOj0gJzAnOwogICAgQkVHSU4KICAgICAgICBXSElMRSBpIDwg MTAwMCBMT09QCiAgICAgICAgICAgIHAgOj0gcCB8fCAnLicgfHwgaTo6dGV4dDsKICAgICAgICAg ICAgaSA6PSBpICsgMTsKICAgICAgICAgICAgSU5TRVJUIElOVE8gY29tbWVudCAocGF0aCkgVkFM VUVTIChwOjpsdHJlZSk7CiAgICAgICAgICAgIENPTU1JVDsKICAgICAgICBFTkQgTE9PUDsKICAg IEVORAokJDsKYGBgCgpJZiBpbmRleCBjcmVhdGlvbiBpcyBkZWxheWVkIHVudGlsIGFmdGVyIGlu c2VydGlvbnMsIHRoZW4gdGhlIGluc2VydGlvbnMKc3VjY2VlZCBidXQgaW5kZXggY3JlYXRpb24K ZmFpbHMuCgo= --===============4254447358249807530==--