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 1wDoQP-003OQ3-1z for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 19:00:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wDoQO-00At5i-2a for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 19:00:20 +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.96) (envelope-from ) id 1wDoQO-00At5a-1e for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2026 19:00:20 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wDoQM-00000001W1D-1Svm for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2026 19:00:19 +0000 Received: by mail-ed1-x529.google.com with SMTP id 4fb4d7f45d1cf-672bd8d2400so1930322a12.1 for ; Fri, 17 Apr 2026 12:00:18 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776452417; cv=none; d=google.com; s=arc-20240605; b=C6dQ21h6p/AB2jQcHsqwAUY7bZGacL6whTk+00OiDu8oMF6nky26bL+o3t8IvINGB6 6imkbb+xtsxbTLjL3QFzdIV4ygxDPohOGNcsYH+espaoSQm1HLt6dvV95CbpyiEULbFM CSKOhCBcvl/aVRYXeWAqYk/F8UEQXWQihGRTMEojgb64+xhLTrZrwnECPFL70vxq6mB3 C0i0isYqXcCcw+ZG/SHzACfn9iCb+mf/lHhrsMngQYPiV9xfu+CJPM5RRXiQGvb955I+ nwN47xKnNc4arozNd4VGpD01jbQdE5/uDNZMJXpzi5DdUW8XVBtafOPeoRf/mReozyeK TxnQ== 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=Wd9TiludRq63Kge5ryFpsFWGz8FczEU61sr3fb/X9SM=; fh=uByYCwkyzB453lhNERURsEUZP6hEwnZO1FtZiWeMlgY=; b=H3GI8AyotRJcaChAUy6Nm3PS5qNUYMXa9QBiVXa87N0fok3Pf7RSEDEO4CLrVCCGRi 44jSN6qbpbi/q2QrrqpJZ4DKqUNRdIE4bZxcxXxFBZIBBf0UHEObXxXGvJrBAbLUJEzU mfJIxPD0+edqxncmDF/6UJ/wtlsv1C2sNpG/0eRUuP/yORatWGHFAks/W8nzcp4mAANY 7jiOObEI4+DAgye+OqpfqohF1+8lSnuW+VBmsrS6pXzcIv+PLiPjE8nLs5HVJ9imhFMn 0qgibHgKtdYFIehfquiSm48kEsRUMGCfpg3uXvquqFWnyDD3ttbDFVM/mSEPb0E5H6mG q7ow==; 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=1776452417; x=1777057217; 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=Wd9TiludRq63Kge5ryFpsFWGz8FczEU61sr3fb/X9SM=; b=SxTCEXaTvVALzCttIktHqA13h3htrhuY11akDK/xOVBu2u6kzG2UIRry0xXmsGk7wd NbWmpBp0TwFZnKvgD3EVCIQBxJjmJBtkdZC10QXKLqSlii/V1fK7ZDY4j0yDrXI0y/0o MD8CjtfXI+81l3CQji9jQ7sL/GBJ3cUn/GcR9fDCMEAk5q3Za8JmsyiJOm9ACpXOoPmr a6Ol4yGxlIJcR7Rqfj70zXjZhJJ2J3C7eGSrkVLqXtdf6cOfobwi0rbgkaCp4vznuDqc 9S/MmCzzYGZlcqu/CGP2dnKFy0hH4u+AgJW0LHhK6gwdx+sgB0x/wNTovMmF+uVCc7Y/ bymA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776452417; x=1777057217; 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=Wd9TiludRq63Kge5ryFpsFWGz8FczEU61sr3fb/X9SM=; b=Z0cPHUXykeA3o5hjZQ07F5RE5XYsr6KnBv2msDeaWKdptq5hbDsUdplfJUmhZucQU/ ACvhdYfjghDX92WmFlijlDJEHqRvnD7f2gtferHjfQhm7zljjk+jPrHv92NuUBd+Xly5 s8yEnUclvnOAOOG3OpWkStjwIgGUru7tmNLKyGlkDiVNCTDY4vyuf6lP6fG7DQ/uebb9 GDixC0JO6MvskZBwSBuOzsHK7PO0mJun9xEuuF234aRBy/yxSe1J0/eHUVwYWIHjHMAB O5vsWYK2jGY1NOTvI/Tgcs88PiSTMr7cLoEUUOqIyPetKVXN+KUvnQ74cQQ0VE04y31K hFhg== X-Forwarded-Encrypted: i=1; AFNElJ++3W0GGh4yAcHpgZAcQMTEdv30YWKue6EOrvqZo2tkVEDO4m25x0/+pLKjupcWRKiB16pwG15CeFQzsJzF@lists.postgresql.org X-Gm-Message-State: AOJu0Ywik8VCjAloxMigN4gof/AwZz5AVeKJUhSkHF/iGO1XOerm5LIl z/nJBCrY/WsDE45dBoZ+tqJVlxvs5RezextbdHaXsnDhP9bnWZcDUBa4c7Wz/wf0DXX844AKz8R CfSGRXpTMypeI3eaZLhXq+By+k9HK2Z8= X-Gm-Gg: AeBDiesz5Vf5AuCDxFIx21l4bMPL4oQuGaU+9076J1/LVMoaMEX8WMdD2+pBhelTsv1 a7wwvjbZlYjY3RYhusvigAjrXb66IWpwLG8n0q4Oj9UAE0V3Yst4Wan5Qaqfo6xo+zFfi6SV/Tj SicpiNfk1MpGZX2ZlIz/5vROtImc9/OM7PDjVa88wECk/Ojj4cprNRjh2tNNi0zVblI/WGCH6Cp loHoe3A8+FRYQLovCrENMF+vdo3zwTo19nsajKn2ZCARe0i/D1Jc8wMxCy/cWnTDc+KoDwSI7W7 YH4MJKdrZPRBjy9nezGzRogWVk8mm9LKChvLeNL9XxMYlihzlA== X-Received: by 2002:a17:907:61a7:b0:ba0:fb42:c232 with SMTP id a640c23a62f3a-ba41917051fmr173065566b.20.1776452417152; Fri, 17 Apr 2026 12:00:17 -0700 (PDT) MIME-Version: 1.0 References: <3683430.1775173413@sss.pgh.pa.us> <3817825.1775240432@sss.pgh.pa.us> <3877210.1775272486@sss.pgh.pa.us> <2672940.1775599547@sss.pgh.pa.us> In-Reply-To: From: Robert Haas Date: Fri, 17 Apr 2026 15:00:05 -0400 X-Gm-Features: AQROBzBOcfKypxniYDgFADNdoCjlDX4kSWdQTcJ6MOyKlFqa7XFniOBgAKDBr5U Message-ID: Subject: Re: pg_plan_advice To: Tender Wang Cc: Alexander Lakhin , Melanie Plageman , Nathan Bossart , Tom Lane , Lukas Fittl , PostgreSQL Hackers , "heikki.linnakangas" 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, Apr 15, 2026 at 9:45=E2=80=AFPM Tender Wang wr= ote: > I try a quick fix as follow: Thanks, but that's not quite correct: it filters out the unique relids only after testing the list, and also copies the list an extra time unnecessarily. I've pushed a fix that I believe to be correct, with a test case. --=20 Robert Haas EDB: http://www.enterprisedb.com