Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j6F4b-0002rw-4F for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2020 14:51:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j6F4Z-0001tN-9l for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2020 14:51:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j6F4Y-0001tE-TJ for pgsql-hackers@lists.postgresql.org; Mon, 24 Feb 2020 14:51:03 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j6F4T-0000z8-UC for pgsql-hackers@postgresql.org; Mon, 24 Feb 2020 14:51:01 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 01OEorO9016649; Mon, 24 Feb 2020 09:50:53 -0500 From: Tom Lane To: Aditya Toshniwal cc: Andres Freund , pgsql-hackers@postgresql.org Subject: Re: PG v12.2 - Setting jit_above_cost is causing the server to crash In-reply-to: References: <20200224071649.ggrhej4n7dq4ruwo@alap3.anarazel.de> Comments: In-reply-to Aditya Toshniwal message dated "Mon, 24 Feb 2020 13:05:19 +0530" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <16647.1582555853.1@sss.pgh.pa.us> Date: Mon, 24 Feb 2020 09:50:53 -0500 Message-ID: <16648.1582555853@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Aditya Toshniwal writes: > On Mon, Feb 24, 2020 at 12:46 PM Andres Freund wrote: >> This isn't reproducible here. Are you sure that you're running on a >> clean installation? > Yes I did a fresh installation using installer provided here - > https://www.enterprisedb.com/downloads/postgresql There is apparently something wrong with the JIT stuff in EDB's 12.2 build for macOS. At least, that's the conclusion I came to after off-list discussion with the submitter of bug #16264, which has pretty much exactly this symptom (especially if you're seeing "signal 9" reports in the postmaster log). For him, either disabling JIT or reverting to 12.1 made it go away. regards, tom lane