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.96) (envelope-from ) id 1wcDH0-003Aug-1T for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Jun 2026 02:23:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcDGz-00Ep63-10 for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Jun 2026 02:23:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wcDGy-00Ep5v-2v for pgsql-bugs@lists.postgresql.org; Wed, 24 Jun 2026 02:23:29 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wcDGw-000000021iO-3zSK for pgsql-bugs@lists.postgresql.org; Wed, 24 Jun 2026 02:23:28 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-43ccd4f6f6eso544233fac.0 for ; Tue, 23 Jun 2026 19:23:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782267804; cv=none; d=google.com; s=arc-20240605; b=iAXuQ/qJjMGtwNJloRbqre1f1YxO3kfh8ySxVixqhifqMa2kkU8Gg5FO5zE3QjrpAF O+u+Wzme76dnlkqbUy6rSjJpOuJkxCNLTg4HVvXhVOebvERG0A1CGt0YgWKyCeHrzTjL f4uf+y+XqFC5gADFaG5agUxIGu6G8FghDogI9hDzX1xiaWbFS4pI/aC74oFIBU8fjdX5 3w/irStZxcFhDX1XfHtGF5sjXhUQXVNRrgfFMsorWdsuFUDS6BfIcgO5rbwAdk17LKMa WpP/eNT+QFOMXb7klgyKIpflmQ+Cmo70RerHEZ8cGVmApjEKS/kWuXvFFvPI06m+Khdz M4HA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=sGbLvjpt3OfLW/497hpTX9LDu0fsz8+AGfoIA0IjgC8=; fh=BcammXGLbId/LvJNqjAb8POd1n0D0gtVlS3w1aRCffE=; b=FQm07G5w4Ejb5fXxYIxwwCwWjeZr82gZHzTaves+x0661lV71G3g9Dqmyv5bCixslC JjDvj0SwMIRwVVRhgw+ObD3EXHteES+fZtFuhVYztw8I3yx6U7hMAoQmAkm+ug/jN+oW adux2l6Z64vrRuHVA84+pbNoAfZgonoEhRcSD5urBn4EyyzhnLT5hCDM8aLltin6vzLZ nVLXXEU9dEwSILhCTPnzHLULSiCmKvBm8446LuRBZtPCqDYuuZnOv4p3aa9+D8Az0mvA HrVlElWFAi4onY8ubtRwoUj3KMOBTktEJffgrvh0ybp9uClhCxeswdnXc2dsPWtnVEaW UVYw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782267804; x=1782872604; 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=sGbLvjpt3OfLW/497hpTX9LDu0fsz8+AGfoIA0IjgC8=; b=k06y2FMVDBBMLAB2UqweEAuuPVJhYzVaptwbhogM3nV5JaaMMvX/tE8PDMyOEC+Vqr qfX+FjKybYeZbzfSrzDTlaVDeNV/ddXfdoM5JM1q40faWo9mEGir9DZvTTrKr3XeXqn0 VcGRi9xoIze/1n0M46PrvpeQyqGL8s8tfx8r1RaLniDFPtzB6cJ+T/3+QXHCkaLZrESe bLCnVh3Y6BzHK2xoSL7fKtdZzmHL48RM94IxEqeONinff9GR23tfd+TC9ru2DxFZwRF1 T6DKZtFPe2AluQG3nDRFeLKoi5apzX0C7kCpxiy0xXy9EepGBpEeEGMazgGFRhcEUmFB AKuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782267804; x=1782872604; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=sGbLvjpt3OfLW/497hpTX9LDu0fsz8+AGfoIA0IjgC8=; b=foSssX4mX9Ihw84pldpfu9JuJxHjoBFR+4d3T+1KLci1CXQuuZHsU3a3EupGwr4mw8 4xWFV6wWsrSEgRw2le9HZXdWPHbo12F5ny5CWyt3kEesMRn847LgdlZ6ja31wbcbV8MK TQOddAVg8LXomQzoXHEv93lVpGmZqC3qDzKXsq1rt9/gZy+iXWgV34EUnfDLw0DBi+e6 kfIXy2vw6P7YPw+xZP3HUhFiyLQqoVjCwRX/KU0qp02bVZmt1SVEv2cz+r2wA3qFZRoy oP3pe2OzH6KAqPKMjvVDBWvd6+IWGCONZuBWA/JtlMdBz2gVfsVG5nsGZ0LSnXu89vA1 +rZA== X-Forwarded-Encrypted: i=1; AFNElJ8D7ZzT2xZotT+Bw1zZ8/PC8jjgVG4gGEAUQ4qFZx8J5KycI3uEpUv+2HR4/cMSbVFApusd9eDoPTYk@lists.postgresql.org X-Gm-Message-State: AOJu0YwUJOc0ZiJGb+g7wDWcMzC8URR0o76KyrFpNDGBHkRm77KUjRTI L3moWec9qfZ33LMA6CkaBev4vNJClvyjkMVBxlDGC4hy9/ptNCshEoU2GSMOf1WmU/xjSBpJuiD +sbKLh2wa5bNsijq3vVd+Y9AvwSy+4/M= X-Gm-Gg: AfdE7clEMbwnZEPLbg+VbzGKseptCzss280pI5zfInAjkQhw/Sz0X1yUBKI5EijfNyd JUblq7l2wpD14IiQ5TXwsQWzJD/21ex440bv+4Pzx2sL3TFjfOk+XZdTcw0Lt0ciQ5Qjd6T6o5c S9vHSRxUjpvS6l3MKqRpEcmp0TYOV5OtZxiTH09vld2nhARCuEly4Md9Vc39scVeM0juQ5pPEy7 q8xngNMWCCz7NaAQqlY+LX86gtl/qcmw6Na/JtEIT+9x1Lbrg22HQ3XxTldKjSpLYoXweAgRg== X-Received: by 2002:a05:6870:2399:b0:424:684:c423 with SMTP id 586e51a60fabf-447dca7211amr1068271fac.18.1782267804415; Tue, 23 Jun 2026 19:23:24 -0700 (PDT) MIME-Version: 1.0 References: <19484-a3cb82c8cde3c8fa@postgresql.org> In-Reply-To: From: Richard Guo Date: Wed, 24 Jun 2026 11:23:12 +0900 X-Gm-Features: AVVi8CcREUzHMvOrBIFcicfBQRtIzCbbD0RwNZcwiZTL8PtNdkOF8tj2VWLHZzc Message-ID: Subject: Re: BUG #19484: Segmentation fault triggered by FDW To: Amit Langote Cc: Etsuro Fujita , Matheus Alcantara , Ayush Tiwari , Rafia Sabih , 798604270@qq.com, pgsql-bugs@lists.postgresql.org, Amit Langote Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 24, 2026 at 10:43=E2=80=AFAM Amit Langote wrote: > If we=E2=80=99d rather avoid it, I have a no-field alternative for REL_18= : show_modifytable_info() is the only reader of the re-indexed list, and it= can recompute the mapping from node->resultRelations and node->fdwPrivList= s, both plan-ordered and untouched by pruning. This sounds like a nice solution. Since show_modifytable_info() is only used for EXPLAIN, I guess the recompute overhead on the re-indexed list should be fine. - Richard