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 1mBnU7-0005r7-9y for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Aug 2021 00:13:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mBnU5-0000mk-B5 for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Aug 2021 00:13:09 +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 1mBnU5-0000mc-3F for pgsql-hackers@lists.postgresql.org; Fri, 06 Aug 2021 00:13:09 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mBnU1-00014T-Af for pgsql-hackers@postgresql.org; Fri, 06 Aug 2021 00:13:07 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 1760D3FY2442242; Thu, 5 Aug 2021 20:13:03 -0400 From: Tom Lane To: Mark Dilger cc: PostgreSQL-development Subject: Re: Assert triggered during RE_compile_and_cache In-reply-to: <2437330.1628205382@sss.pgh.pa.us> References: <0203588E-E609-43AF-9F4F-902854231EE7@enterprisedb.com> <7F9BFA6F-9BC6-4A27-BFA1-2F01682BD644@enterprisedb.com> <2426993.1628201727@sss.pgh.pa.us> <29C525E6-A912-459F-BE27-217F25F76B5E@enterprisedb.com> <2437330.1628205382@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Thu, 05 Aug 2021 19:16:22 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2442240.1628208783.1@sss.pgh.pa.us> Date: Thu, 05 Aug 2021 20:13:03 -0400 Message-ID: <2442241.1628208783@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I wrote: > Hm. I thought that this might be an old issue, but I'm not seeing the > crash in pre-v14 branches. That means it's some bug introduced in > the performance improvements I did a few months ago. Open item added. git bisect says the trouble started with ea1268f6301cc7adce571cc9c5ebe8d9342a2ef4 is the first bad commit commit ea1268f6301cc7adce571cc9c5ebe8d9342a2ef4 Author: Tom Lane Date: Sat Feb 20 19:26:41 2021 -0500 Avoid generating extra subre tree nodes for capturing parentheses. I probably won't be able to dig deeper for a little while. regards, tom lane