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 1vve2A-00Bhcf-1v for pgsql-performance@arkaria.postgresql.org; Thu, 26 Feb 2026 16:16:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vve28-00E2UN-2L for pgsql-performance@arkaria.postgresql.org; Thu, 26 Feb 2026 16:16:12 +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 1vve28-00E2UE-12 for pgsql-performance@lists.postgresql.org; Thu, 26 Feb 2026 16:16:12 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vve21-00000001Q2S-38RJ for pgsql-performance@postgresql.org; Thu, 26 Feb 2026 16:16:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1772122563; x=1772727363; i=atiware@gmx.net; bh=i1SQsRioD6891Dx0blgrOfvAEAmik6+BP3iVNvl9HOw=; h=X-UI-Sender-Class:Content-Type:Mime-Version:Subject:From: In-Reply-To:Date:Cc:Content-Transfer-Encoding:Message-Id: References:To:cc:content-transfer-encoding:content-type:date:from: message-id:mime-version:reply-to:subject:to; b=brRgJ4J6RO/bboFP1c8lmDs2VUWc2U5ok9oIwEUDKCZD2Rrz6pw0Em1pBkHc3Gay A4zqOKDFgcXMETKC/N5ghpPidyrTqMaTdn+lcO4n0rtM6+M+KnJbbjFihxYTkw+JA Cb8rFi9aPj4wMJqUYFmAag3qwjwvA2Cf/HoaFvqXlY7QXJB6p61QwjTntong/CGKv aAkHcpAtK9Gknh7isD72ebROJbZgrYZgnsQstaVeMFZR9TFbY/oAFFTNuMev7h51O dvho5Of0U1A6ptOaODQ9uRqigyMnfZrXjK4nnQ6JUjLQqAOk93NZgRQaq30aRAiuM 0aTnRiQhgAyh6ejE5g== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MXGrE-1wCaXF0u6g-00N0TT; Thu, 26 Feb 2026 17:16:03 +0100 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.400.21\)) Subject: Re: unstable query plan on pg 16,17,18 From: Attila Soki In-Reply-To: <45AA83DB-A6B4-43A2-879B-290E4A7845AE@gmx.net> Date: Thu, 26 Feb 2026 17:15:52 +0100 Cc: pgsql-performance@postgresql.org, Laurenz Albe Content-Transfer-Encoding: quoted-printable Message-Id: <33A1B02B-1FDD-4F5F-8370-26DA72490009@gmx.net> References: <64ddfe83-317c-4cf1-b04f-cb74d9f40629@gmail.com> <529E2365-6C3F-4BDA-9625-312F3A023C5B@gmx.net> <5bace3e5-3d6b-4f81-92a9-9ff4e9e5de53@gmail.com> <1C445A2F-3256-4F04-B55D-9850581FF39A@gmx.net> <0dd76506-053e-4a30-9f95-9dc324e8e1fb@gmail.com> <1388B912-7E9A-475A-93AA-67FB99A084BC@gmx.net> <0c8b9845-a2ac-4613-8075-45dc55911143@gmail.com> <45AA83DB-A6B4-43A2-879B-290E4A7845AE@gmx.net> To: Andrei Lepikhov X-Mailer: Apple Mail (2.3864.400.21) X-Provags-ID: V03:K1:j77Ah8kWqlslXXtMarIza8O9/In3XiYGcW6DyMdd0SkQ6wNjAtO /2N8B0Q4AorvAbWtc5clBfh65TxWeycGwf7eCHCqmG+wz742hD0G/CExD/kZs4b/T1FjNd1 ACrbR82bJ5C3lXlPNw2L2LUl2jEV0gOemga2UUXFjokY5BAoY+OCGANaHhz8vt8Bbcet0IO 9TC4xcTSJIhcyQviTw1CQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:a9sXadV6230=;2eg15nPa0Jo0CRnx96QBmJr+CO+ gyDSCXsXN0Qx7cPbY2MqCcMy7HDlegxb0uBGothi7EjCnaWEmZHYhn1qrxoZ3nw3VMits32RT 0sNNQRD+I2Kvnfkitey9yJ9zjMwpY0nYFOLrYXKG+k8QXRPIgPsH16oVpSgNswTH7wj1ooa2P zVBZMmMCeh1nabFs9BJGB2vL94bW2C/ltOKVXO4aiTNa+nFyO7ccAxcROkdq2iGLDSMsgdp7M iOvO7fZY89ajwLiHRmTG+D3X4aBnLlhHk7Qj/cmVti54/4UuUNYP5DoUTm+unl+eKoZRfsP2s DIU4Sxwa2u1w7IhljgLpf+PBxtHS1OPayOuiT3pEyjgz9AG3505rYbC/0i4TTzA9H/18pAxu7 eWnS1ItBRIou443NtqeF9QvVjQgHqTiWajrIMEYIHhAB/qU+BV1L6ca0a9Ar0yPib2DLJ+ZLW ulWBivDU7CrgK+yaPu6d8moCaEht5MsY6EL9cPUoIGOTPm/n3fEZckgQzdYEK1Tb3FKI9ZpYN EaVwTMOTYF1B8O9YgoQrqBkmH/rWuhJawfwvW3Cw/e9o6JsnzoRbRAoLhbkFwyDiaJD3s84yg xKTlmt+z/64ctELOp4uPhjAlbISJ6bjqJ35ZmQr2mIMXpngMWAtGLO2zJVLO7S/Y9tdd9z4r8 0w7praLRTw85bJf6gG8xhvYmztX3pkl9N+RbhG5I1TxJg1n45cOqluF5day2XufrOfgQE7rZ0 +Jq8HKRlnvlPFsvjxpTOzLODC0EpKFX4unB9bbsv7kBM48XN//le82Hx9+UCTelbL+aY1SzAG /U19n2p3yghcpmA1EqaayimlKKFRsHOvmabsgl68hoqvSgzm1+ujK8ut2QCXeZDBosGGO2FIb wYrWrbR5Ft+Q6oiGccQ6LLzernbOnyH8+ApkGbbmIx5KBp95O4hPhdg4Vi+zwIDAri3qauNkC xQ364BmQf0OfNJkcC+xn+aruUWQbUxp9WMuOiL+LZtlN4F67zGAsyubNhiX3ub44Oght49JPQ zxSoinV7GSKa08uptz5ppK1sdmyTIK3eaE8UvCqapM6wYXs92M5yWUjLSAKM2HU6K7kVw+FDI wThoD0IaXDjw4xsHQq7xYRZGBHFVCeBT1hFrPFxbDQOjUmRyJhMA708fTkVQgucmQgTWjurPd aaImmy1R8QC5LeqtAKG0G0wd+72xMaqYnFRsZGtbmDIzBbFZQhPISzMTIJ9DpAzRAo6CfQO/i eYw2ofTGPu7EU1c6lleSFkI4PFWVP5OEHxDAhvlqSahCSo7eo0vqKAPRiXadkEelyP5nXN9eF QP+zv3MY16orOmaA317nzDZhzWJxKGWT/3RIWEiNEBazzgQbLqvxva+m6fVBYuHCifzerasIb OnU7J+7ZOmt5TqPxiCdIcgcxhtf1o+gJkgwBRH6ZWYCD2tWgH8cTwpZm+j6uE6VeG4bInPqcu Yg6kn8ln+qmkM4LGY6ZPA3rjDsJFzEyk8+wzeB9Rfym+F9XyptYsm6zaJ9xcZ5Z/2J5QnX0dY xdKixhVlc8o6CZ2bs8Pu4WXJungK6XJW65Xsw+ytZenJtMOGtqQ45UoQIJhDtSxx1y/2KQ+SP 9ku3NRAGeCc5q10HI/GLQox8lv1XoirHGWiyn/XDI+xvgwAoA3ymLfEJRIcYZ2yup7xrEQak4 tBbF49BAkTMgEPpm6o3EtN6MK2ZbE4vTClzthAnup7C56iO7ASV67uzwIdUTCLDXfiwI6mFDo kDdJc/ZtDeinTgebEOfJuCwx1CiXz9UTnxd/Bq7fmgqs0QCa++WKVp8/CpZpTySnJpASYqhT3 557qRTqUeJM3JaurFTkZ0EZdZuPuD1Djb+LecWzNa/WgGy2TjrssHBGxRIY+LQmhOT+kPlKqy 0btRBuVfF29Ed42CUe93m7rtMaK8s3LsziAoZUBNmQsObs8STjw+rdL16caw/fMCvJuhc0r2V h+ewpPbQ8kqkdW4s6ZD7zCi5JYg0/f0sYwPiXUife+Mav2QRFUseGVQS6+qe/hHwcF9zZRwHA iWooEE6RyEwiBzquglHgcp5aNlqURL3SItmFQ6jrRFLaIsRmk41vgE6U96kUunlBQbJdu552l S4kg3sfeDD070xd7hg6pWvVNH8rxlMEGAP1UqvFW9oppoNKqVq3dqpDUprC4M4N975l4pSA6n ++VzPdY5tKRN0CyxRsSI3ZJdEvSy6gAS7y8Oq+mQJlREkd06iXOCCOizISzpSHHx21sSLktXY cl/YvBCWM3c3Rs3QhcqNyXy1thqjmLtHIVrRQ58wOiZbR59cXBH+PG6T4cRdgXTrWYN6Wj6SW RpYx140iaZ0BYeo4ADtG23UEWLhqKkEdlSzXJcMuavhkLRLvDNXuxej8xIOjWfn+yqiavvgb2 E/dV0dZ/hBUhhROFefkbmF4H1YM8GZxyuKjk9VSb/J4/0ZBalpAns8cgeY4Vgjv0ffxdrJxsR cFRrcn0re3j8VP6YrDyheczJCoohztRgMDOcTl5RCpV5T86e5v13Tw4SxVXla08kR1L2xk1nu wBd/kkjCoCliFdxorlpWCgSuxjkarV5lCVtfvpAe1JeTLgPj2deYVzQiaBGRuE2yKv6d9IIbR NhyWJ95mgCLrzeaqjIiasat6sDHgB9kC9VZz/2vuj0aVyo/CePmY014wLYMvA9/Zj3/el07rw ctyhnM67mv16BHG5xntmlmJB6mAysqxqfcGMAq5Wbp0rlcREF15D0Z+WF+zN5L+LXH8FLWKcy 988kMmQe+GrXTPESz7Xxwv8tj5gEo+Uxh42D/4pBhMKir2KNRSZwrwHWmcd9z6kOUO7yrbw4V Ga2uxjOXO3JkSPYxQZruq70ihpOT80dBcAurH3k0pNTc5oq//1NiImCo2W1E9GgCX2nacC7Gg 9MyRziiKF/gU4CeHrRDRrApJFKqbj0ChDrs7oL2xSJUyHSKIKn+qreu5KGPiDcws0ihAgdz2m nyxKZ/PJoli/A5Zw9suUn9MgBNkN+qvLEmjzyrWejGfoVwDEr82cGdTq7N9hia+XXbeSSyp8L 9/t1c1f6lfTNHGVdYWFQHe6uWYE2r5I8tmMNC2QOYh+zQwqlFx2eNvIBD5W3uRrhxvom7YWcy cCaDGYCoZ+JYf17Y1iAJP9I3kLu1E+3JIOcZoPWJRyUqE+75DQD/j1XaYQXlvEpGfglN3ZVoo dt7KTeu3cOft6o0Kv/ey7KM6opgEvrne8uB+843QxHlRY037Zdkbn0BatFs11kgZzHa9RYfw4 o5pTFj63yUlbDiaia8/pDZBO7WbClZ7xPdz/temf7nsnHCi5AZGnrB6l90pYJr3uDhdYcIMP+ jqpfOiyba5I4draOAyqdOeFkI97hGM+BWROJfdPFbM7kXzd/Q4PPxAseuqQST4OCq6cXMNjrj gR8/4pCJRnfKb6/i7ISSWBlE2moYaUkjh+LdTYrzjB7ZZdI5Gw9bFqDbAKDYk+IdBAIND+JZo 6+Q7u0P7BJfFpkKfxPp78DiO0uvIsyHD+7N6Vs4SBHplbH2r0Mcucxgjg1/zjuYVeFpJVjAN5 MImu0XVUqLIpmZJjKj2Vg/5l9psYy1eBTNYGWpSab3l8IuKpBj2GyQilrmHxDg84Kq2pelID6 UK+iLxlbGgRucFDH79R3Puz4/5+a8ImPX3AXvrUfzXC4Vu6YQ5MoaeftZLZepwN8dl2opEHTZ R/rtIFHpR5CiZt7Tn4SIHPsnWPi3CSu8fyOEaWoKqvHHdd1dRW8Ve4mSZ0LJ4IzV672q0yndB F6CsPodGbpwPEpQ9CMJesVcIzAlD2h3TxeQGAjiL0awyhDvj8vMNBoXU+uBmJIsTvJez4l0Rx xbfvX/V8FeIgXGADie7HDva0Q7NiIRt93C/p3Pbn4KWgKHslutEV2eGl1LPMCJdK5PH2MDgTg AIuMXNujw/EOxuXUO1QmywVryvwAO8FsdhyOGFth96LIVSIxTWABHyPxPmcERKndBFVo9fAPU SLGRcXsIoZgeJ3sCwx/VLGybCrXQnEtl8b21EcaLQxL2am6WVgKDpixZyt0FskBpBhWmkhB0Y SJb/pX0nfsfBI/xDKIuuAJrM3CsraVxesG6FpuKrQoNNypIrq3bHVli3kVQMbidRz47lC1Ixo tic6rCVWFq52EXmu5v50UaW69BxEbmLbcN3eMGLUR6tg2IRF3P4Xw9w9WlsXHyfKf8uUNN1kE oLpRajtkICMzkzdwEz6Tt1FuLtL7X8iXpbgzhLTTJHht8zylHybwW8TnVBtDq3vjfxANQ5nYZ 6r5ha24tpMM7yMq+7km3Nt448kymEzNMTvj2BXD2XA+9iq+uQUxFdDgF7VTTu+Sf844vQIDxf +2LvKeNJE6Auj4spWhpppQzv7A0KesGXi4Tq4urlL++Ot4S1xBBOEXkeONs8hSN14BlWcubyE PG6g8Q2Qrw3hnvymu+R79JaWEz1HYmXZAMoS4nIIhJshICGEnrFgfJp45yvkqoIqxsJmgQzD/ halD4MTQZxRHtS15IpVHvjQR3hiU6fwexH+CiwBcV/PWrqEBQKDqh2gJihG3JTzE95zh/wRwV /NLW6gNSGwG5tSgfTkNul+EoZHzZiWNyiafinAVL1yV4Stl3vG7nfUWaqX/axT98oEk144ddq 8zmPoAJrILraHA/p9D7CO4FUKaeyhX5/vFuQk6RSD01SOxHo0j05eFLxzS8RrRImdAO3kP5Hn isUYua83pb1ozHXBStHOyXwlrECWwTxFV/64PGx1pEDZleqNaWRcSNYepofqrOca5/VaEvXbP BpyIWXbOY8k3RmcBqXcUa8cwY6foXSEa9qzQdCSrx9OgMbXjdByxjhBadgjvIOV8xj7NZa64T XfQ4HbRjHrLvd4azi8KKilgnr+ZJg2GYe4bzQMJp2nsqY/t197+5GmiFwZEa16wDq8IkiPgtt 300beXKzCmK8DwJLIstyHtaK9rEGwkIbyUjm+QOLtBvYUQI6C7k+D9bThdWeI6AwZ+u7pO7eo EmeWWcX0ejo+b1G2Y5r2EqfXH0vdgTZDfwqD0NuPvrEY0btwpfHZf9EyiXKyKOdAkMRDB3t5V Q6CLPyPlpe/qJsAXuCKsWn+ScgZsYlDpBdaKJ1cxP3BpMuT6FMOuqF9JjmhsSh6zDZTjUArFa 35K/Bh/8QbvGLYoSchbJojKkalfgvs55boKbZR List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 24 Feb 2026, at 17:48, Attila Soki wrote: >=20 >> On 24 Feb 2026, at 16:57, Andrei Lepikhov wrote: >>=20 >> On 24/2/26 16:50, Attila Soki wrote: >>> Now with join_collapse_limit=3D7 works for me and I am not able to = flip the plan. makes that sense? >>=20 >> It is almost a game of chance. But if it solves your problem - why = not ;)? >>=20 >>> should I still test with increased statistic on table_k.dp_end_dat = as Laurenz suggested? >>=20 >> Yes, it may provide us additional info for developing. > ok i try that and come with more info. > Should I set join_collapse_limit back to default for this test? >=20 Increasing the statistics of dp_end_dat did not helped. With statistic = 1000 I was not able to get a good plan without setting = join_collapse_limit=3D7 regards, Attila=