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 1r8MJ0-009T7x-JN for pgsql-sql@arkaria.postgresql.org; Wed, 29 Nov 2023 15:16:50 +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 1r8MIy-00BMjv-TO for pgsql-sql@arkaria.postgresql.org; Wed, 29 Nov 2023 15:16:48 +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 1r8MIy-00BMhB-K0 for pgsql-sql@lists.postgresql.org; Wed, 29 Nov 2023 15:16:48 +0000 Received: from fgw23-4.mail.saunalahti.fi ([62.142.5.110]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8MIq-007xOW-SG for pgsql-sql@lists.postgresql.org; Wed, 29 Nov 2023 15:16:47 +0000 Received: from [192.168.10.105] (88-113-210-75.elisa-laajakaista.fi [88.113.210.75]) by fgw23.mail.saunalahti.fi (Halon) with ESMTP id 49d4d13e-8eca-11ee-b972-005056bdfda7; Wed, 29 Nov 2023 17:16:37 +0200 (EET) Message-ID: <1439ce7f-5053-4a61-8237-df7c301e8518@elisanet.fi> Date: Wed, 29 Nov 2023 17:16:36 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: pgsql-sql@lists.postgresql.org From: Richard Schmidlechner Subject: Re: Bad execution plan when joining partitioned tables Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, After updating db statistics the number of estimated rows has been correct VACUUM ANALYZE a; VACUUM ANALYZE b;