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 1vxoy7-00HAYK-0k for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 16:21:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxoy5-00DdLA-1u for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 16:21:02 +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 1vxoy5-00DdKi-0u for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 16:21:01 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxoy3-00000000Ysi-0CoY for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 16:21:01 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-b8f992167dcso705490966b.1 for ; Wed, 04 Mar 2026 08:20:58 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772641258; cv=none; d=google.com; s=arc-20240605; b=QxtlA6Ysymw6uYo4G5uFabkcgUOAAA1ZIZZ+Xo2nOQPuWabfx9oF8jAHkqf9ebpRhj CNQNvpcHCAraCkN2rpvYEtXG7vzsiJrIg9WLpu+6X1z123t+dDqhO/OPIZjFnC1FFNSz YQOORFFuOFwQYQ2QYJ8VF3oKSV+kSQ/eXWjTMqQZtvgFWHZoWUsc3mloAp/3eomup4um 7jx3b89nmsIZCFq+G45FZ6c+jL6zZz2EkLHH8h1U7f4LH7GABnFOhLQDsG/GX6TjoMTt 2enTYJepRqP6pz5L1Q9L6H8H/cxp98cVcQ0zG2SkZV9mqe2E3/ytli2oP5S/WrdrbedS b5GQ== 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=dzsH7F1ignYraB2T2e0h3nFWfun7ft4dbUYJRkChVqg=; fh=0/Uia762Zy0fPK8IMhcwfZypHNdnz33Ns/6gYdtYkp8=; b=ZMi4a7FpRCqrK4gaztvv4xxio1QYgHuuPhh0bXEHTCDpYUaVn2mL1oAHosEXQowLGG UJnLRnXGL7Ua9x03kqjLZ83+61pvwAzOskrCE42sEYCygxKq7Yj0cGjL0i2YtJaxAcwE rdKWDoeE9jIFEZwxa6OGnSmMGIOl4cSrgYjmdtmca4GGIAQp9DOSDxfwCAO9XdYMiy35 X2+4b0PIjaXCTWM4IpASpF5ILnPG1QxNL4lub5Zimk3J1Ti9ad0jqg5hnlpH5qZQO2hS T7D1vKAHccQZiMYq0nfhZztsbAzyZ6z8DZTXq+PqvYTZNmP/ycHm2cVNT6LRiFW17Lun gEWw==; 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=20230601; t=1772641258; x=1773246058; 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=dzsH7F1ignYraB2T2e0h3nFWfun7ft4dbUYJRkChVqg=; b=joR13Ris/eQ6CjVGRt+lddLqxyhyf98fGwGQi5e8RCNHCI+ozJvDJ1ODzfhvFkevZX aSGJQlVJNd36VkiRseAt/3RML/uHwVw7OODC68fMmz5Rx75gzeJhmRN7eHonYsNs6Vqj l1qzo5Ufofpe0DCbvgXTB8W6ut+BQWKJ4ywzjfbg7dwnKMfNlomRzh5ReQppE4o9+dTL K0XajrQHipg1JWbwjfLE+vktUtMYh5sw2/UFh1bN3ExEGRckAYdzcFaPpNYwNUao+ygq fH33GUaN4pe0YnwJVQuKvTdgScfxg0OZgjmtNRDvLEJKTYoS+1Ug+SA9lIHqu80o3MnI P9wQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772641258; x=1773246058; 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=dzsH7F1ignYraB2T2e0h3nFWfun7ft4dbUYJRkChVqg=; b=Ea8+EioMZ2xh+zkOpPNeakZQ+q1SxcSltir9ze7RyGKwumSPeEuOhU9gIInTsEpVc7 k8NBkcMayltRqaSUvuBEg7YGdGjGfhhaeJtfqYAdvLT0snJAHkEWxMEROxb4mU2gvF4u YndvbGk/nAyh2wZ59HG1EqAv3yExiNPONUjJ/DgNKDc71BQ1CDNpYvgMWO+w6UhPl3o7 zzzcmw6vADibrjrnA/Sc/qWroN3oPoRrDCUXYkaiX+aZq2EPtZL2mGHYKJwSUwymnZwb uSIIBk1Kjs5s2Jv9oFpLUXOBO0g0oaUkYPoLU62wjZ/l+KTBwSL2xKdc+6BBX1QDxije xqCg== X-Forwarded-Encrypted: i=1; AJvYcCV4uhSHScdDQQKfs5HxPMdzEfedIOeV66qS8uosesfz9TxfeiwhKBZy1wQmsEunmUSpDXiTKlssBEfbpsYe@lists.postgresql.org X-Gm-Message-State: AOJu0YytfvVAE/KVFYz351VqAUrh7yVyc+zut+S5zzlZ1lANwx7M4je3 b/Jh1vfkTKccRXc73pOmKJdDOPeFQNC870x02trIuRkAYATugdlDBpQv+sH6ovjy/xr1O7S0flf p6QY04n5e4Mzla4nm6Em6yD/vK1x3p+0= X-Gm-Gg: ATEYQzzqqexnPPKOOuMi3F77EXsKYf0OUUFiETSLT/RpLr9I3X3wpCZtTCPAycWJjxc eisr6gXTZ1j+VaTMgXCRKxwdcsF0fOhudoSugx0mq8cjUiIAq19obO+IXDDlm9Yo143kAHEPhmN BYOS6bxhkv20fHTIJv5pyHqwZrA+N2ZCwmkoaD/s3pI0Lmy5GSEU7Z4T+2m4BRCKpUCXCIurTqW MvlmlQCMAAitMta/7ucFKfL4vTj6zUXM4AjGB/OZeQUxNFgGvLTWOKvd5W8gtAmtMjHv0bFvLjS lOew0HEJ6TISiQDcsiWpfBRh/XCLWWHR36nYk4M= X-Received: by 2002:a17:907:72c1:b0:b87:6:371d with SMTP id a640c23a62f3a-b93f1536301mr142426766b.49.1772641257462; Wed, 04 Mar 2026 08:20:57 -0800 (PST) MIME-Version: 1.0 References: <1136161.1769654478@sss.pgh.pa.us> In-Reply-To: From: Robert Haas Date: Wed, 4 Mar 2026 11:20:45 -0500 X-Gm-Features: AaiRm52uVHrNojto9ZbbjmF9PLW-1PuSdGlCSj6A-jeGrzqRFJVWLdWbGhrypoU Message-ID: Subject: Re: pg_plan_advice To: "David G. Johnston" Cc: Alexandra Wang , Richard Guo , Lukas Fittl , Tom Lane , Jacob Champion , Dian Fay , Matheus Alcantara , Jakub Wartak , PostgreSQL Hackers 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, Mar 4, 2026 at 10:45=E2=80=AFAM David G. Johnston wrote: > I do need to work in a way to better annotate/comment on the why of these= . Any suggestions for a better flow or feedback format? Inline comments w= rapped in sgml comments? Or just copy the diff into the email body and inl= ine comment there - leaving the original diff attachment as-is? My suggestion is to break these fixes up into three categories: clear errors, stylistic suggestions, substantive concerns. Clear errors can be handled by just sending a patch that fixes all the clear errors without changing anything else. If I intended to write "applied" and I actually typed "aplied," it's fine to bundle that with 10 other mistakes and submit them without commentary. For substantive concerns, I think it's most helpful to just quote the patch hunk in the body of your email and say what your concern is. If you have suggested wording feel free to suggest that as well, but I'd focus more on saying what the problem is rather than jumping to the solution. At least some of these are cases where what I wrote wasn't sufficient for you to understand the patch, which a very fair issue to raise, but if you try to write your own wording, the fact that you don't understand the patch makes it hard for you to write quality documentation for it. If you say "I read where you said X and I tried Y and it seemed like the wrong thing happened, so either the documentation sucks or the code is buggy," now we're having a worthwhile conversation. If you just change the documentation based on your understanding of the results of an undisclosed experiment, I feel like the chances of the result being an improvement are not great. Stylistic concerns are the most complicated. If your concern is something like "this sentence is hard to understand," I'd class that as a substantive concern and treat it the same way. Beyond that, I'm not really sure. Honestly, I think we may just have different stylistic preferences, because my experience so far reading your proposed documentation patches is that I tend to agree with relatively little of what you want to do. I believe, though, that other committers feel differently about it and find your proposed changes quite helpful. So I'm not sure exactly what to recommend here, but perhaps take a lighter touch when it's my patch? I'm OK with some friendly suggestions that I can accept or reject, but going through a huge list of minor wording tweaks is as much work as going through a substantial review of the code itself, but for a lot less benefit, especially if they all look like random changes that I don't understand why you're proposing. Hope that makes sense and isn't too harsh. Thanks, --=20 Robert Haas EDB: http://www.enterprisedb.com