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 1qyBLH-006fVR-7A for pgsql-general@arkaria.postgresql.org; Wed, 01 Nov 2023 13:33:07 +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 1qyBLF-007Joc-Et for pgsql-general@arkaria.postgresql.org; Wed, 01 Nov 2023 13:33:05 +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 1qyBLE-007JnY-W7 for pgsql-general@lists.postgresql.org; Wed, 01 Nov 2023 13:33:05 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyBL6-003RwR-Ns for pgsql-general@lists.postgresql.org; Wed, 01 Nov 2023 13:33:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1698845572; x=1699450372; i=jimis@gmx.net; bh=cr4seIHjb5nQBTzZphnITkYZ2+nR/P/6kUswGwf9iLw=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To: References; b=RZ4tnnSry3djDAQIv5/S21xivZFAzbfbCFDxscgljx5+K+lddUezhvH8qwMm3cBi T0gYEWC0WiREL1YvGLa7xbUSq4ysg/BXf9gzc59adXfkyUrGpxilSuiUi3Ghknfxe NdeSi3M+i00BsGWGVZhuwTay/nkVrhIBWDPiZs5JrFPA/UKp1pgp+em/YwGbV1TnE bFM/GufxaMqErJ1+JKBQqiJe5mpCcCi6AfLb3voPKBuBKKspen/4nOkSWDX0ifLL3 p8cI1FJTkAI7tSyudGPJ1NNVOkOmDVnxfThkihObxVBz/VSCVq5vCS61ySoqz9u9j pVA2QV0U7ydwtK2aAg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.65] ([185.55.107.82]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N3se8-1rOgQ00cYC-00zrqQ; Wed, 01 Nov 2023 14:32:52 +0100 Date: Wed, 1 Nov 2023 14:32:51 +0100 (CET) From: Dimitrios Apostolou To: David Rowley cc: pgsql-general@lists.postgresql.org Subject: Re: Inefficient query plan for SELECT ... EXCEPT ... In-Reply-To: Message-ID: References: <86c352b6-c0ec-8c4d-9506-297506b1b5da@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:RpoDVXaI3upB4Esk+WsVjZu51gHbSUuI3AWMTfEq4DOWuU4O44T dAIPt1jXbWoyo5AqiGVHc1zjJyywpV9gtkL71cjfm3+jN/vb0N6s7fEJVudJFxUdBG7Pdh8 NHpy9DstQLnvhQ2cS6FQuWHL7SB9O4vWNStppD80swDjtqCSmP1JB2RY37PKr+SRXUHHXWX Ygcfnx/Ik7E1X+Vh0C2Og== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:AfXleblIO0s=;iuljbQgW/kN6/404JqKhks+7JfK uF7OiA4k0YsbkbRADOPsQseNlXBq9RQOd4Jy/B7heWB+N2YU/Fagcgi6THEQKIdcIN8cmxfO2 F+4XZGGyEjsoqKwRpiXG9aNEc5MMRoYP/jOON0klqAgKgk0E3RyIjvsR+AuKaECkiOB3KWTFS wHrRGmfyps2YNAWCSRTxT4hWYCKqqrpxFNyVp/MrOCfO7T4VD5Le5JwOlJMOZjNz7uGWrCAxL 304NxZvPdqYZRtr2Vi5YIzDcRdTYEMQJJ6RYJpo52K3y7+VQTTIOQHOTeKGJDdSs5swF20bm5 xjN/0DJLJbhcLAgAYILenelpNR6xLinNDheTWxzxv3JwTl9lXixeGWwoczPD4YfimZFPLqMMr VHACETV+gKmuqtyso9sJ3+ei7Gk+O+S0CyptByp4m7j584r981GnaSa7mCUuac2EDWx3Kct1v +UJA8/ByAfBtRb0cfP0T89uxYu10dsk8uH7HWmqnZE6B90kPIHE7gzVeM9AkRRarkgw8thRmP Vnzzo1uG4kTbML5JyisfUqpJ54kzGWJiZjt1WfMVjfHvPHq8snn6F/6Ucd85xtLycNRVHMICH /zAht1ZjtZqf3BwaQ7yoqSnONxFew75YaGx6+RdxUt41CGTBSz76MNgU0ip7mWaAoI/+X3osp q/B5pOitCujNvAynl7LPOiW3NB98K42MBh1PvMdfHidw2tnB8Qnqo84SUcOSZba98zgwP03L6 LlyhSKy0BwX75EFSy2/GUVExz3Hn2UTfdGaLiv9NBTBN14zoBtvEHyTrW3BVweHIbzNVN1b1U HB/Qpbo/s+PtYnawEg7qTOJIjEO8u81FfREka6wySZZ89OAAs60YrE2SvGwMSMuX5nDjzgKMy 0ntXAfCbXOAursfPcbllCRexoWlIqg5OhgDE/xtjkNrwKln+bIOy8W3xt Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thank you all for the answers, they covered me well. >> Is this worth a bug report? I can file one if the issue is not known. > > No. It's just a missing optimisation. We know about it. It's good I shot an email first then. FWIW my usual way in other projects would be to check the bugtracker, and just "follow" the relevant issue if it's minor like a missing optimisation. I didn't find a way to search for "known issues" in the Postgresql project. Dimitris