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 1tp5S4-000K2U-CA for pgsql-committers@arkaria.postgresql.org; Mon, 03 Mar 2025 13:03:20 +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 1tp5S2-0078Ov-9i for pgsql-committers@arkaria.postgresql.org; Mon, 03 Mar 2025 13:03:18 +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 1tp5S2-0078Ma-28 for pgsql-committers@lists.postgresql.org; Mon, 03 Mar 2025 13:03:18 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tp5Rz-000iKQ-30 for pgsql-committers@lists.postgresql.org; Mon, 03 Mar 2025 13:03:17 +0000 Received: by mail-oi1-x235.google.com with SMTP id 5614622812f47-3f415d5e096so2276835b6e.3 for ; Mon, 03 Mar 2025 05:03:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741006995; x=1741611795; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=NMknPzldLJpm6IkOxaA4nAYDW//Sj0RgZWHGfAuxf9w=; b=J7T6Cctzvf7l+JXh2oDnVem+9TokViKTZzo+xtr6sjqh1iqZRwCU6GEr9GOoJDG8MD lEgnVPScwuXALO63Cc6gIH7UrpqkszAw6uPugsgN+Azoob3m0fD7bJHVsQW1F4UDvJvh ovG+hsUCdhxbPN9JMDLi0uBaapwYbRmVkF+UDtjx1UiZsgmMakV/MrcQUoC96pqCZnBA 5ceCa3AeAICwnog2DkBVYjJD2nhL/sXwf4PE3ogxqOZxrnqrrGeF5AgazO+/cJTvGuDF BynUcc1Yo+1/NueyGLSbWVm7Gmoi+wr07k+6O1+tSOjuRJrYCfl4vy1HqPd2ahP2RXQl Dk0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741006995; x=1741611795; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=NMknPzldLJpm6IkOxaA4nAYDW//Sj0RgZWHGfAuxf9w=; b=tmq1WJtvmcDmmgJuYEdg7J0vwFYpzr5QhvwbHkz5407dIjumOnhd3Xpy8DKvl1pjyc 1iYep0sc7rRuj2YBiJBoVUUferSh7BEsWK0Nq9HtjJ/kJnBWcPBhdJ/FdMjBxolF3whL p3yIypbVUn89mSIqckY/iBgsuPJnYdSQJ1YYK7/wbqMGPKqKAySgxO8xHbg++mkLzfHO xrTf1Q2f9RMSPpTQrYr244sqBH9Y7nW6MU/LrPWEDaREum4OdmyFjReYkpyUf4KLbHrT tJ0UKhRjYtLrqzjtaNfyc6LzGij1OpEqLQ3XRcbGhU0q+qbLVBkzYGYQtvvGfh6SlXlT +KHA== X-Gm-Message-State: AOJu0Yw4Bw3j+hmDlWgk5WdNZSVF7sfxEY4Wtu0hJMOSCuHtjpiai3zR lkDJbHGI8f4GyZX16lX79rtKd6FGqC5+WOHaUTj2WKb5Dnez99/q0G1Rie9NmNSQ01kS2w55AvF ZQ8P1og0VUTtdDMQP461UKMFYJV89PpKD X-Gm-Gg: ASbGncsblW83SzuPJn7bTKtbx1yaa9bFoeagJUXh1qtZpUndPyNlq5YGfdtoxbYfuGS 3YYyMzgC0bAx54mUfhHsf1TddY76XCAmNAJGTPeqAW2UnQYvZpCQm+yhk0Iinnrku9c/7LuOXDT 5HyCxGSQ1Aw2n9/tcob34AsKM0xGs= X-Google-Smtp-Source: AGHT+IGy7D+9YXBn9tVjj2RgG3RrLREfW3NCZ1ZuDOwtMKB1mrdC4a+s4huTRC1JqBQpHB+nOhMjxRVv+Hzh7/KxGDc= X-Received: by 2002:a05:6808:2a0d:b0:3f6:7782:b5c8 with SMTP id 5614622812f47-3f67782b934mr28278b6e.4.1741006994647; Mon, 03 Mar 2025 05:03:14 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Robins Tharakan Date: Mon, 3 Mar 2025 23:32:37 +1030 X-Gm-Features: AQ5f1JpRzsqxkImT4uUtS5cJqitl6xJqWfXVlxkor-Bd7RIPvPlPaG15l-p5vGw Message-ID: Subject: Re: pgsql: Track unpruned relids to avoid processing pruned relations To: Amit Langote Cc: pgsql-committers@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000077b16d062f6fc7f0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000077b16d062f6fc7f0 Content-Type: text/plain; charset="UTF-8" Hi Amit, On Fri, 7 Feb 2025 at 18:45, Amit Langote wrote: > Track unpruned relids to avoid processing pruned relations > > Since this change, the SQL in the bug-report #18830 [1] segfaults reliably. The SQL was tested with commits as recent as 15a79c7311 (2nd March), so it appears unrelated to the other Merge fixes that went in. Ref: 1. https://www.postgresql.org/message-id/18830-1f31ea1dc930d444%40postgresql.org - robins --00000000000077b16d062f6fc7f0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Amit,

On Fri, 7 Feb 2025 at 18:45, Amit Langote <amitlan@postgresql.org> wrote:
Track unpruned relids to avoid process= ing pruned relations


Since this change, the SQL in the bug-= report #18830 [1] segfaults reliably.=C2=A0

The SQ= L was tested with commits as recent as=C2=A015a79c7311 (2nd March),
so it appears unrelated to the other Merge fixes that went in.

-
robins
--00000000000077b16d062f6fc7f0--