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 <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1tpLuB-003ybb-Dd
	for pgsql-committers@arkaria.postgresql.org; Tue, 04 Mar 2025 06:37:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1tpLu9-007a6p-7y
	for pgsql-committers@arkaria.postgresql.org; Tue, 04 Mar 2025 06:37:25 +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 <amitlangote09@gmail.com>)
	id 1tpLu9-007a6h-0q
	for pgsql-committers@lists.postgresql.org; Tue, 04 Mar 2025 06:37:25 +0000
Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <amitlangote09@gmail.com>)
	id 1tpLu7-000rPu-0G
	for pgsql-committers@lists.postgresql.org;
	Tue, 04 Mar 2025 06:37:24 +0000
Received: by mail-pj1-x102d.google.com with SMTP id
 98e67ed59e1d1-2ff087762bbso2831489a91.3
        for <pgsql-committers@lists.postgresql.org>;
 Mon, 03 Mar 2025 22:37:23 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1741070242; x=1741675042;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=pBT3OvRi4wPyCZK58I1btZayaEpOubfFszvRHUbFEt4=;
        b=jGdIgpCVxSCdCF8zojTDreHRlQfa14pzkgyYLx7EVnvRg3tWfm49EyZiNn4SKBd9HH
         8Al+awokKR6EOY7XiTz33qE+bNYwmMWFJ56FEzEbhFEYNDvLA93vxZILJ5LhDETcdi1K
         xA68xv4w3+nFhL7naEA91ePrZqziasOxL6NuIweWNt0iHMCBlOg9UC40Gu1h5JvJ5+Jk
         4DL3npFnNRU8DqHViLoQzB9iR10YpQGF/qFg7/ZmUHhH7Ite9Xvw/vK5KEFIwJaL2Dkk
         L2Dlpo8ChIXErBomMz25YtmSE8tP5U7URJLKioncFxicKqRcx+ymdhgarWS43d4DBtIg
         1bdw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1741070242; x=1741675042;
        h=content-transfer-encoding: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=pBT3OvRi4wPyCZK58I1btZayaEpOubfFszvRHUbFEt4=;
        b=h483TKL8I4z33kTfjETpCnYc70EL2PBwDMMGzNw9yVVolOAhOJrKYClpxJMUudw7K7
         7xCnkiufepiC3nXk9o0ibJy0Tp7BTzcnNEJd1UjFHj7qIZbvVtlLyuzK+2ZNhX3dp//N
         9P6vhwYd3zN2siEyDHibgOMzH03EaQAJ2XpFGkBf7MuIXsw183NRCpf9nIINCrxi8VLv
         ki0/w5hbcVQEdZbk5tt4UnPWHWf8A9IwzRmLsrEqfN9lBbt5qF32nY6MxsGzRLGc6bsa
         ChHHNOclg2HdOxgk0ukmPtXUApNXQ1Gitifvnb27VgH9Z8P8xlYiJm7jASDIDkFl8Dw3
         lRdg==
X-Forwarded-Encrypted: i=1;
 AJvYcCW91HPrTLevG2v9xrOwOsLq4GY/W0/yiUnpmmzK6ExCuaDkuYkgp9YFTIL5Oa8zmMP6D8A6VoOcKrWsM7lDjNe8@lists.postgresql.org
X-Gm-Message-State: AOJu0YzG1I/TUsD8+Va4DkS5U8J3+2Qp7+5zFwEaaN/I3HBYdMfnZnXV
	BIBNGb/o310oUHUYF5Ko1+GxelGIrVX16oox5M5J4dysJlMeFarbfozB3+0S8lUrcfDIR4K3t+n
	xXWRNQAkp5B8jpiX8tr7vtg9yocU=
X-Gm-Gg: ASbGncupgxNIGuwQTCdt2xb92K1HRVUETIgsGrF2919nfMhQa3WYQj6a9UYN6TQvUt3
	oIc7OEXxycpbXxXHCNlRbRpYQYbLi4v8h1e1yW6ssNsfkHAk6lFRoCJkYv14itATg5iArkqgvnA
	OXTB4nmrl+9L5Rtsisz0IK8LRzFnA=
X-Google-Smtp-Source: 
 AGHT+IEf0ec6jCbKL1YKXi4MtMm0BXrI4p1kqe4j9VDS6nkXvj9q3NQxbqbqf6t3XlsQuQcQrz4uaZ5/plVGR614Q3o=
X-Received: by 2002:a17:90a:d605:b0:2ee:c04a:4281 with SMTP id
 98e67ed59e1d1-2febab2ec9cmr23824210a91.6.1741070241711; Mon, 03 Mar 2025
 22:37:21 -0800 (PST)
MIME-Version: 1.0
References: <E1tgJWO-005oNz-RN@gemulon.postgresql.org>
 <CAEP4nAyYHhqkCF1RsUVN1+aviNYbZnQLuYAvKfBtzBjnrKGxqw@mail.gmail.com>
In-Reply-To: 
 <CAEP4nAyYHhqkCF1RsUVN1+aviNYbZnQLuYAvKfBtzBjnrKGxqw@mail.gmail.com>
From: Amit Langote <amitlangote09@gmail.com>
Date: Tue, 4 Mar 2025 12:07:05 +0530
X-Gm-Features: AQ5f1Jrmqhw_vR9AliNYntmfgNpmeP7Iw35YZM8ZY4LxlJG5tcVOl1F-WToxzYg
Message-ID: 
 <CA+HiwqHvULmSaO1aSf5Y9st39PrSdt6Ff2St7HnTkj+Vn_2BWw@mail.gmail.com>
Subject: Re: pgsql: Track unpruned relids to avoid processing pruned relations
To: Robins Tharakan <tharakan@gmail.com>
Cc: Amit Langote <amitlan@postgresql.org>,
 pgsql-committers@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BHiwqHvULmSaO1aSf5Y9st39PrSdt6Ff2St7HnTkj%2BVn_2BWw%40mail.gmail.com>
Precedence: bulk

On Mon, Mar 3, 2025 at 6:33=E2=80=AFPM Robins Tharakan <tharakan@gmail.com>=
 wrote:
> On Fri, 7 Feb 2025 at 18:45, Amit Langote <amitlan@postgresql.org> wrote:
>>
>> Track unpruned relids to avoid processing pruned relations
>>
>
> Since this change, the SQL in the bug-report #18830 [1] segfaults reliabl=
y.
>
> 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%40postgre=
sql.org

Thanks, looking.

--=20
Thanks, Amit Langote