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 1w9lbn-001jB0-0v for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 15:11:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9lbl-009hcq-2E for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 15:11:22 +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 1w9lbl-009hcg-1F for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 15:11:21 +0000 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9lbj-00000000uwf-0TmG for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 15:11:21 +0000 Received: by mail-wm1-x32e.google.com with SMTP id 5b1f17b1804b1-488b0e1b870so17207235e9.2 for ; Mon, 06 Apr 2026 08:11:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775488278; x=1776093078; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=PorHaJiI3S7jde1Xf6aLxfoR23uoOQQIg0rrlAye/xI=; b=FszIFMQtKoY/v6fHZ0brT1DNpvnYGo+o6rXoy9jkyAgT/6gkYvYbIXau+hW7pCOPds 6xbOECCQ6CW3Gfv0bD724K554WGO/AIqbuIL6HxZ7hFo+UTZLrTWc7+7H91FbQr2q681 gj2p3J+xvgq3LC6bGIQgYAjZTiZqtVSrXXeJK+Es5qVzgcpc1DqMor3DlhqrOVhXZkWH zwdxjG5XrYgOYCBPSzTQHnqMZXvTFvVEtc5Zv3nReZZHr/hqK/quQEgQbnbAdGA0YvnF kdfkb0Ek8DWgkDzSWqmPrl/ACJFgumz4oe46FxxRmzKkN0k+GzKyu/HLaPSI4Z5CECut 41MQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775488278; x=1776093078; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=PorHaJiI3S7jde1Xf6aLxfoR23uoOQQIg0rrlAye/xI=; b=bpw17xVDFYx/IGprn/2aJ+37v4AoDdUOkvnzs3cDXKhU+uRHzvK6itDaMMdgO12Lj3 6BJ2Xc//uppDH7qC/3kZy6R5FqFJ2K0iHisWUguPo4q17E4sHYNkJ1TCxe8u95NYL0dA cYiiq9Fit235mH1Z+A0xqjPQtPdROJIMHHx9KNCCxHFMCo21tPH3v/pDXfyQaJd4CLwg /IODT85er5JXNxHiVngyj/4ANNVw7Y4yImo+eN/A3AXFuvn28BF+FpWlIQOUahFd8/MF /ykg/NkBr9KIGXA89ZnFRipVjo8vvbTLIn4kRsPDgFfgy/5d2C3wQuvyc7yfxK08jkkr IvaQ== X-Forwarded-Encrypted: i=1; AJvYcCXmXfhlPvgxdNPZU+7oXiNG+0SLuyzNSElkQ0jqKOJx8DtwZ8+cJzjdzC/fb0jL5c5E9gma3JhFpkdRjQRO@lists.postgresql.org X-Gm-Message-State: AOJu0Yyp2fZsNtICZFItOLcn6SsuksQn/Ky1qkTR8l/70/IuS5BETN4F 2nc52Vi/kqm0cnhPIJCHf6wdWtv/TDpW544TNC0nY/So+TsPiVsSdzNU X-Gm-Gg: AeBDievQ/zgzWGyVPP5cZmxU8k8oU+1scGVncVLzHtkW5SwWb/BDG80RnuUVvpKtBDw PQoTVSiFPiEsyh4A6zyaxfqfyOIaAPFq1yjAnII8q4H53ovQEZZKFaAa3GuSngs4yvp7+DqKNRG 0LOQlrR1ySB1cBnjDd06buA4fYwWM5GQz4iQlw/+19aK9pZtnQatQTrY5age+mdk87U6RxBPG5U /8+yUVp4e6fR+eus00o7fLslXGaonNeEjjJRc1B7jsj8E0335YYIEm0BvJvjiP1cfhjMJpDl/zN oKRGvYnWoq1npWCcml1ZNpJowL3qiHlOhCTS37kGdlvBMMuWPmNIpuVh/cXpHSqM+gHZxCS5chu lw1WiCPkqYSOxyIWkjX8Wc7vgsfaOH3ycfJo//43nZYFIL8PmRkVz78pwTkpre9K93B8ZQ/6lnR DgK+/ZquvG/81+VFnfpDdJhTze4uag7G9YrRjSZw== X-Received: by 2002:a05:600c:c114:b0:488:b919:b97f with SMTP id 5b1f17b1804b1-488b919d744mr13208985e9.26.1775488277636; Mon, 06 Apr 2026 08:11:17 -0700 (PDT) Received: from [192.168.15.156] ([80.251.191.198]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-48899ec1898sm94460565e9.33.2026.04.06.08.11.16 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 06 Apr 2026 08:11:17 -0700 (PDT) Message-ID: <7d2526ac-d688-4b1a-bd49-70581d01b5fc@gmail.com> Date: Mon, 6 Apr 2026 17:11:15 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_plan_advice To: Andres Freund Cc: Robert Haas , Tom Lane , Alexander Lakhin , Lukas Fittl , PostgreSQL Hackers References: <3683430.1775173413@sss.pgh.pa.us> <3817825.1775240432@sss.pgh.pa.us> <3877210.1775272486@sss.pgh.pa.us> <386d8c06-0f96-40bb-b1b1-107db209c676@gmail.com> <2e7bdb5d-68ba-4c65-9931-a865ab6fc3d2@gmail.com> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 06/04/2026 15:56, Andres Freund wrote: > You're making sweeping high-level demands, implying they're easy ("when I > designed ... this kind of problem couldn’t have happened"), without any > concrete technical suggestions for how to actually achieve that. In very > strong language. Your high level demand, that somehow plan shape influencing > code should just work regardless of what crazy thing extensions have done > seems ... not entirely realistic, to put it very kindly. Sorry about that. I haven't had much practice with English. Sometimes, things I wouldn't normally say in technical discussions in my native language come out here. As well as part of the meaning definitely lost in translation. The actual reason was to highlight that quite closely related features exist in the Postgres world (not only pg_hint_plan). Even if we can’t expose the code of enterprise forks, it worth to discuss alternative design ideas. -- regards, Andrei Lepikhov, pgEdge