Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n9WYL-0005jk-Dx for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Jan 2022 18:16:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9WYK-0003k7-4W for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Jan 2022 18:16:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n9WYJ-0003jy-RF for pgsql-hackers@lists.postgresql.org; Mon, 17 Jan 2022 18:16:23 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n9WYC-0005dO-Sz for pgsql-hackers@postgresql.org; Mon, 17 Jan 2022 18:16:23 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 9D9203200BF9; Mon, 17 Jan 2022 13:16:12 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Mon, 17 Jan 2022 13:16:12 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; bh=5+BXy5LLk+mS3Y2ltS7KgNMASBogPc9e3de0QH6Ibbg=; b=PzdPv7it ac3bHf1HYY5cdBtjfxfHXdyJP2CSga+lAQaxS2x7svcrQli5JUobl74K4IGha+/X NeLURANfJojEr39ygIFAY3pJDROHzkVaMCSV2eKGTmy9ivYB025niC482TnGKqLI tD9I8LxkQYsnvn+rPDsMdTz93D41Q1rvA4SjmDjsqZd0bUxWev2ZkTEtQIOZV38/ be4F5LGu6q2N6Wxs3Qb20Bm2ZFasfPHsUGa6uhaoepyxWNxGPLaUArssS7oTB9mm ipy0jXeg5aHqj9YZ5zzpsrJvhOEWfjGBTpXimboESCjfQX3xDPERf/Ey6yPFPWTy C2Yy1RtMgnJNvA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddruddugdduuddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 17 Jan 2022 13:16:11 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 671C72A0808; Mon, 17 Jan 2022 15:16:08 -0300 (-03) Date: Mon, 17 Jan 2022 15:16:08 -0300 From: Alvaro Herrera To: Arne Roland Cc: Julien Rouhaud , pgsql-hackers Subject: Re: missing indexes in indexlist with partitioned tables Message-ID: <202201171816.r6tkrn7drkm3@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <405b11a5a0504b76b997e312e543a69b@index.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hmm, can you show cases of queries for which having this new partIndexlist changes plans? -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Saca el libro que tu religión considere como el indicado para encontrar la oración que traiga paz a tu alma. Luego rebootea el computador y ve si funciona" (Carlos Duclós)