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 1w9kYJ-001i4g-2I for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 14:03:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9kYI-008tt1-0H for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 14:03:42 +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 1w9kWn-008qhm-15 for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 14:02:09 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9kWl-00000000uJj-0FMO for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 14:02:09 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-66c4c7e2bb7so5243711a12.0 for ; Mon, 06 Apr 2026 07:02:06 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775484126; cv=none; d=google.com; s=arc-20240605; b=XeWLVCMjmLKNjMAh2OUNQBRP94n2BbIwkbmF63Gq9AGinQZTDOyNXuUOjExAfB3A9e eFMEf9+cqgPRl4eKM6S52rzHm5vNmuBWDlaxJV2W4Z5ZFgqG5Hawhj/VLUfeDHR9EfFo +WtZ5xVG++Hd64+OjWfs2nQp4YyKmDYjv+11Itj+juvmemQDrZDAnLFTkHp/jFugvbSo ZWq8w18Fo6tf2c9CCUCUsSyTg4o0OiiNEyiA34EfHoHRI8NcqJPyol015GTqi7YR8Y3D HNhY7gK46toWICF6rElPNIvvEvazA9ZM113tT4UaAD5QyPk9aLcLgC2zhx/ZkpYnng9j /HSQ== 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=JkI2dI+8ofi46MVDk2FmkzBMuBOdTTq3eHLUFyZp3fM=; fh=QS/Kaq28Yg21JSpFrnd5/46Hg0z/WaFGlkOTCHhZQX4=; b=KR6jhrnsbNCkJBmYOZqjK2q3zaJWCCCBue6qVKjXcP0VftlWvExBI1LLaWLSlc3K0i oPiyx6UHFs/ysqv5LQ27jNW+nVnnr0HyL2s5DlbchLbUIhV1apldJRUuIs96+Fi9S4WV 9G6q3WBgsUn6PmfmqoDxYvemk4CAgHT6FFqImpt/4KXWa2Z5cUfvvi+O9qv3HrADONJI b6kHqEUunaCj0pyGDfUQSMe+F8LNObQeh7djdj0Oz5dy5jscIkOH+BHj68GTZShKMpZh j48Py17xQ9cCE/0d+lf+rhrM/d01a4xBOQHGmmuPM2B7idaezEn1Ng7yYOEFUDX19oJD XbgA==; 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=1775484126; x=1776088926; 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=JkI2dI+8ofi46MVDk2FmkzBMuBOdTTq3eHLUFyZp3fM=; b=sfzD8Jr3naY4spotOZsGErn1pvVRIj3ozdUnKCDT0ulzjp/cc5Gw1IiHzGy6GCngLf b4q8lNbcslKn6nxjguSzWyYgrIT094t6a7biPGaXxRy2PLREJThqEmtHAEl9sEFO4VYu c34jEdnquCsHupZ3asjAlWwA1MTopaRJFb7QZmdkisyPx1zginYp9zcGUYq90fCjp1GZ UqZnph+7sNkIXJ12UBZVgrUFGdPHmZ2wJo4UYm8drYmMRXHo8ORJPxPDNWsIdnT8GxVe xgEUDLajmSytaBcFKoafHVCsHFClan6SQUa2OAv+6wQEB/Pd7nUH1cVP3YN5l1xKTkwe YOQQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775484126; x=1776088926; 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=JkI2dI+8ofi46MVDk2FmkzBMuBOdTTq3eHLUFyZp3fM=; b=LXVif5XDmZl+yeYSm/aV4tntqHzImopKKnLvbsT/wK1fAU+fL+6p7b3/OatqPBstJ8 sSU/2kPSz6nW8psh/D2DSzvVTcm1Py2ny2F5HZI2F4aj4uFbxMV3w5MOZoMj3vSvHOH+ og0OncoEDJrJY5o7dRHpJ3LZkgl894YlQO1j1p6r97fVU5VxmhGEsErPrkDB6bWEMTTr FOiYEAgeob7jpFfvb4/RLK3omABBbcbPU58SFNuOc5djPAUEqzhkkyh9qOdyS1tcZwg6 bQDvKq5DLuxLqKgfe+pkfJWAzNTGQXQ1L9Aj6MjAkf1PYR9gBD3AdgQ76uRhtB+74G0d QQoA== X-Forwarded-Encrypted: i=1; AJvYcCXN82JEY7eSskV5PpoPSgTJYgdsC97DYP2j7PR5mqz2hFU5mXiHUhfhNWuM3d0JNXAf7ZzooPD+BFHvVJRg@lists.postgresql.org X-Gm-Message-State: AOJu0Yz1bChJSo9rtxGyu3G+84MFvOOUb3EvCOQd+IVf3Y0kzBpXieuZ hF5OGR+A/EM/GlEWmSj9gd+n18rH4kOVu+LfLO2wKX5QfwMmMZIpaTn5pvdVuCpkQ31ffyff1xC FJ4CD41l1J2IJq7p7gBHp363XLhs45bs= X-Gm-Gg: AeBDievK/YM7TzeKmDEEcmNOj4s4a8PxhJVInTy8Ql/EGnH+VlvE7+ndVk7za+T0LkM 1IIaOK+IsolbvnSD6EAmqstf/W6L4FJW0pFpKMw6LJkaTaH4XQa2Cc4gCgpmWCXvfKT0dJhUHhi 646HM0l9WT7pd49+ILsXKaxJBo2QdVC/gHEugOy1zmoi5eNQWnFssdHHIlqZ6qQ+BI0HLn9AU16 IHf6mU6zW2EdjpPvUpshx4V4YcbTaG/BLLBRWKd34zTYPCWAdtyLy3gjRnZV7ncCZ8n9S5gZD/F JYlWFQjNLz5WNuGQEl2zNw+t8VhoP/MC3gYtBcI= X-Received: by 2002:a17:907:9705:b0:b9c:7dc2:e45b with SMTP id a640c23a62f3a-b9c7dc2f2c9mr537477766b.18.1775484125678; Mon, 06 Apr 2026 07:02:05 -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> <386d8c06-0f96-40bb-b1b1-107db209c676@gmail.com> <2e7bdb5d-68ba-4c65-9931-a865ab6fc3d2@gmail.com> In-Reply-To: From: Robert Haas Date: Mon, 6 Apr 2026 10:01:52 -0400 X-Gm-Features: AQROBzB4QgJK7aqrk2i4pWZ4mwIYMaBWMgs7H8vBOtSGfpdaiYyca9Pqt77ARIw Message-ID: Subject: Re: pg_plan_advice To: Andrei Lepikhov Cc: Tom Lane , Alexander Lakhin , Lukas Fittl , 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 Mon, Apr 6, 2026 at 9:22=E2=80=AFAM Andrei Lepikhov = wrote: > So, I envision complaints about conflicting extensions in the near > future - think about Citus or TimescaleDB optimisations, for example. Definitely possible. > It would be better to introduce such a code at the beginning of the > development cycle, not right before the code freeze. At least we would > discuss its design without rushing. Yes, the timing is not ideal. However, I posted the patch on October 30th and committed the main patch on March 12th. I think that's a reasonable length of time to wait for people to provide feedback. During that time, the only person who provided information on how this will interact with out-of-core extensions was Lukas Fittl, who came to the conclusion that the pgs_mask infrastructure will be reusable by pg_hint_plan and will result in that module being simpler and involving less code duplication. Other extension authors could have provided feedback during that time as well, but none did, even after I posted to my blog to try to raise the visibility of this project. As far as I can tell, most extension developers don't pay much attention to core development until after we ship a beta. Had I waited until July to commit, I think there's a chance that it would have simply resulted in me getting whatever feedback I'm going to get next summer rather than this summer. At least this way, the issues will hopefully be fresh in my mind when the feedback arrives. Of course, you also seem to be assuming that whatever feedback I get will be negative, and it may well be. But, there is also some tiny possibility that I have done a good job and that people will like it. --=20 Robert Haas EDB: http://www.enterprisedb.com