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.94.2) (envelope-from ) id 1qlrGb-004djh-1n for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Sep 2023 13:41:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qlrGZ-00DBfr-P2 for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Sep 2023 13:41:19 +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.94.2) (envelope-from ) id 1qlrGY-00DBcv-G7 for pgsql-hackers@lists.postgresql.org; Thu, 28 Sep 2023 13:41:19 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlrGV-0077wM-8e for pgsql-hackers@lists.postgresql.org; Thu, 28 Sep 2023 13:41:17 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 8404B3200983; Thu, 28 Sep 2023 09:41:12 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Thu, 28 Sep 2023 09:41:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1695908472; x= 1695994872; bh=dkt847bPNuugzo8rBRUI4V1ACSRmnBpKaIGsTczS7f4=; b=e A4sYAtsya/BWgIKP7QrrK1JA/OKdiNc7r7Jct71bM8r/LVLucjxmuhDMY5xwUXC/ GfjpNg5CbQBR9gYtrw57vCG+w3sECDDF9YtnVhJqL7DshhfQ4kCHfWjpYgeFEX+v JLzpESPDo1md+KUcFKCDoyfMbtItoKJCK1i5/GV3en8fr+DgTbpeXSzotrJt7GLb bxsrk7/rdjdotTrq3O+/JQRqyi9D7ywo21ZE9UZvuL56dlWidiTYmmnYD6T4vURo 2c0o4uagnA58Zk+NNZc95dE8TKW6J15g7txKWSQntOW7l134tVFYwt2ejtDcEmAc lsbuOFzHlj81woT/RPwnA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrtddtgdefkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeff gfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 28 Sep 2023 09:41:11 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1695908466; bh=AG1mmn/KoF3P24fEeBfauBQvExS3lqLnGn1YEYqZNPI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=qFnJ1R9hwYZZyhLO6tByYBDkJ3dlG/Y71ZDDUQ9hY9uiEBi3Hi60sRWXYZdirr3BT uRhNjHvWW50wSdwAm+eR/c22oGotOZMnUE3eIGRV0Cuf/o+RjryFnh8jQvTa8htm+N P/vDlqxzhx56GWBVlwjQzMt9Pbbv4YyRtM/C3j0tTqNutCOFI0cd0imhi9qyNa2jqT egkIh+vRJ/deb/2Hy5tNkDTb11ZVQ6dVOfvtjw4WpC33wgqZWr+iSCP3l/33hNFO0S BJaGdBpX9mZsWnxTVsci88IqEQG75wasVbAFIuK8sNCgvbHtw01FOlIGGVVUZmyqHR qv9myZLi8fVtQ== Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 3EFC5B7; Thu, 28 Sep 2023 15:41:06 +0200 (CEST) Date: Thu, 28 Sep 2023 15:41:06 +0200 From: Alvaro Herrera To: David Rowley Cc: PostgreSQL Developers , Andrey Lepikhov Subject: Re: Is it worth adding Assert(false) for unknown paths in print_path()? Message-ID: <202309281341.o6n3nglxq2rx@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-Sep-29, David Rowley wrote: > In [1] Andrey highlighted that I'd forgotten to add print_path() > handling for TidRangePaths in bb437f995. > > I know the OPTIMIZER_DEBUG code isn't exactly well used. I never > personally use it and I work quite a bit in the planner, however, if > we're keeping it, I thought maybe we might get the memo of missing > paths a bit sooner if we add an Assert(false) in the default cases. > > Is the attached worthwhile? Hmm, if we had a buildfarm animal with OPTIMIZER_DEBUG turned on, then I agree it would catch the omission quickly. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "¿Cómo puedes confiar en algo que pagas y que no ves, y no confiar en algo que te dan y te lo muestran?" (Germán Poo)