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 1wCKU4-001sVg-0v for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 16:50:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCKU2-007wmL-1z for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 16:49:59 +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 1wCKU2-007wm6-16 for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 16:49:59 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCKU1-00000000pRg-0qqF for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 16:49:58 +0000 Received: by mail-ej1-x62c.google.com with SMTP id a640c23a62f3a-b9bfcbaa81eso711125166b.1 for ; Mon, 13 Apr 2026 09:49:57 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776098996; cv=none; d=google.com; s=arc-20240605; b=QVoqjY637Sb3RZqr6WGRoaS10kdkEEJfY+OD1HW1tNnL3jTqk6/E2C5KVAQQ0QP+1K hWF7eQtIWYg7Bs5PRBR6UIgikNTBIYvCHNZ4PhuuzO0JZvFCO5bXk5xcrt3z6JUrK7tr 32bcljQR8XqxnQ29us/FNYmxgvgycgdMuG5zXoFSZGlGmQQ4qZAe2HI68N0XqYBAHZ5u 0D1MSjBaixO2SDVxrCcRZqEzwSXB1W4jj1nsQkZEMcuowSK0ERhTJOrjShbvkUcsujD7 r4MQ4UYwt58EZhkP5yb52IFpPkIzDgjiycDtQZ1H3F9LgutP34MvU6e8asPdc30sxyTD Y8gg== 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=pGcyl2Lxx71U1S4q+djUH7nHWRiIMck5Gv4ZwrKR4xg=; fh=ZtWt6Vo7D2rl7LP3S4E0Tv6UKfsTLuVIp9TeA25Ag1g=; b=SLUoYud6OxU6UcaQXhTbBNvqqq8RO3EZBdPKExWpoL/kXEX9KLnCRT8xZSvF3B62Tk ufKNLR6M2ciY01HMZBXMNo1Ttx1wM/w1m8wjsoeObVYOWntfhhnY/MQe8muoAzW/LB9D +bSIOGWDuy0sIvyH8mrev2GtKO0zZr+04LoUFw0OolAVNW6dNQi/2AHxsDMpQNFJfGsl xOGnLWUWR+5W/J/nl1eoqnhPcFS980158VQYHAHx53Q3o0zhI+ewwMysacdNqdhCGOhv O4TTcayadhjFYYCZ01w0HRN+n6V3KKcS3Vu9l+oonSZ4x8RMxSpzkMgzAN+qvgyPEVdO eL+w==; 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=1776098996; x=1776703796; 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=pGcyl2Lxx71U1S4q+djUH7nHWRiIMck5Gv4ZwrKR4xg=; b=mIowM0fII+wDly0EXO6ZcopI0Z/gLQ15E+vH2GRryP+4PpVScQsv1j2YEclTVCmWOm n5hRZeeXG+FFQbnu7YuMro6h3TlBxaUsx90+jFMe7+qy4FmUPHDEUD+VW03oNaAVz7ZX 4tdGGV9riCkuq01yVA+By8qOo2Vpa2mTR5e1V1PI4UrAMhVVy0A6PUFk9pDHO2k6/Zsm 2ft+rld/G6+ZHYtBCG17xhMnizFLfmdtPd7vbyn+rn3ztXpvr3uBPrjgYx4P5KszlyQX yO/d8nBFfF1ZfPcdDo8zcVneDTla9of5LZd1HYU5jhEz2Vj4U+kz8K61I35MxgG3LtPS /GHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776098996; x=1776703796; 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=pGcyl2Lxx71U1S4q+djUH7nHWRiIMck5Gv4ZwrKR4xg=; b=oyU+8Jxz1tFxYbVTYsVqAy/6x7GAIRTs7e3J9zrB//XYAW7XEKc8bXdQBmVxxp8wam GTgM7jHGoV1k0+kXsUR0VYUXQRvbG0I1O/p3Eyw3W7bWgY/TS+kLdb4/7OEZEAwVXvt9 hzE+0C17/Qp8eOgo5TPABD1g2xQVZjwRzqjdI7QiIKOShyU5lfOIkTHJh/ouiuxsXgfV dJ42fS1EMz5hBpmkKJK6ChWZ6HGfV5LBtQAiOyCdXwaIULXBDJZeLSu4aGQNU44Z/Ra1 eUCB0zCAWg9SKj6xfqcejN4sGKbME2El0cdjzScv6URBMJP0dw6iqWRIm3hQcJmSnsvf Ii0A== X-Forwarded-Encrypted: i=1; AFNElJ9t+EFAMMt/A4PcZLKU1RXdDqGaCVpRhxGNnlT+QH10C6z5bTn1yw6iFu+J5AXDDx8ipVSJpc/9j74UxxOi@lists.postgresql.org X-Gm-Message-State: AOJu0YzKAXnxecAwEf6LQcSW60DWeDJ8dECtPwVaxqjWMs3oifzssShi OD3KEYP/DWYPSH6LgXLa+4SFIlN4yD8hiItO08nORNFRQBsKepNQ6gcu+X2YO+gGOAMW1VMVKvY jhOvgTjicazqHfcBZDMtPYIE1jD4y5ZM= X-Gm-Gg: AeBDievBVDqyOZKhbMjJzLYQzhCfHLVq2WrOrQkZc4In+N/ju36lYNfCTeFUCNMWSnS VoHnBrfPL3rVmr1v7B4IklnVkcUzd5HolzSWZeXQ8dviCA6211ZBaiQJIc3eKdWQoWq9trvEES1 snWmr4U3gnLI66hzynCWqe3P61AJaKJiKXnMpBvCVzU88woJAFtT0L+Lc4nI4YcAj1JkjI4TU/P M9R2Tg6YCO09fRJBHLQgu/4Ze7YC6mzd3VspBjStaVyHgZE5Xt97RRLseCPnnjQ47WLAot0IZvN 5Ec+wqvu6B6lP+nBPxyCHN8MvBzXx/8gy1auhcGoliWJl6dxID3ukGggNGz7 X-Received: by 2002:a17:907:6b8e:b0:b9b:e5d:71df with SMTP id a640c23a62f3a-b9d7279334fmr718993966b.19.1776098995670; Mon, 13 Apr 2026 09:49:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Haas Date: Mon, 13 Apr 2026 12:49:43 -0400 X-Gm-Features: AQROBzBkb6Z9MYFuxG3IUlb0MfG9Cd70zWLteiPIHxLqYAjWZ6kn2Dlrjzsh99E Message-ID: Subject: Re: DOCS: pg_plan_advice minor doc fixes To: jie wang Cc: Lakshmi N , pgsql-hackers@postgresql.org, pgsql-hackers@lists.postgresql.org 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 8, 2026 at 3:52=E2=80=AFAM jie wang wrot= e: > I found that this patch is not fully modified and is missing a part: > `Foreign Scan` ---> `Foreign Join` I believe you're wrong about this. EXPLAIN shows "Foreign Scan", not "Foreign Join". Committed without this change. --=20 Robert Haas EDB: http://www.enterprisedb.com