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 1vuugp-00CcXC-38 for pgsql-performance@arkaria.postgresql.org; Tue, 24 Feb 2026 15:51:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vuugo-001iGe-30 for pgsql-performance@arkaria.postgresql.org; Tue, 24 Feb 2026 15:51:10 +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 1vuugo-001iGV-1p for pgsql-performance@lists.postgresql.org; Tue, 24 Feb 2026 15:51:10 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vuugl-000000014kC-2XuH for pgsql-performance@postgresql.org; Tue, 24 Feb 2026 15:51:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1771948266; x=1772553066; i=atiware@gmx.net; bh=DLl0D9A+mF6EQfzo22HnjTz8fmoM+WGyUPIlINIJWrs=; 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=Cxj84maUezTn8Td7FV72lKLknK+P64VpswUgA/83utnWI/jxkwg+AWy1PGNQbkRd oGIADa4vULKn5qfqvi5ffwyxZyQiNR8KaB+LvmcBtJ1L2bcUV9OrdDyyhRavr+0I7 WAyXrxl66MAtSIg2PrwnbUBvha4XHgneXe5xPAZTGzokmIAm9SWbxivTbnTpe2xSu S5IO+hC5CHc6gt/BxSo3Hk4o7A/vw+/CKVZC+3IZMiKDBfZ4P7qzVe+W2GFFlE2bw hCtW1aMPtC9NS8bE5kJvvjqWVMJUHQqtXXAYUZwpczpvFEx54PIyWOLDAHSkbFpdn v9pqs5dRbs2+KuR7KQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from smtpclient.apple ([144.2.66.138]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MKKUp-1w9Pvx19HL-00QRFO; Tue, 24 Feb 2026 16:51:06 +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: Date: Tue, 24 Feb 2026 16:50:55 +0100 Cc: pgsql-performance@postgresql.org, Laurenz Albe Content-Transfer-Encoding: quoted-printable Message-Id: <1388B912-7E9A-475A-93AA-67FB99A084BC@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> To: Andrei Lepikhov X-Mailer: Apple Mail (2.3864.400.21) X-Provags-ID: V03:K1:PrjwhaxC5+4/PBptOgnTuPtwfbXtIbChpH3Uy3iZZDBWn5oqlFq pXr59Yvq9LwvVu+TOHP5TBCMyugVbHZIoKVUTsM2MZtnVKHsQVwWr9ga59wS1OhLE92kNQ5 4QORor/4dMgVqjAFZp0R3IteiTC+avb2bp1J2gNmCId4euFvFKv0d/iVOxqw5Y+kbLZo0Cg dGT0pLmy98bpo1yRh22qg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:vFsj9GjM8Vw=;+XQALe3GAPuV6aE4TsdNPjbFYQv QaF1p+WQoVyUidhgQ5+vOn9MkgDAVIOvDT8i0EjDuDVc/M1gDRl7N4OZ29KKbYA/moxlNIOP+ oJ6NGFGXdOCOqN0AUswA2ozzebQCZuuDo2YVDjxF7Ch+wUiGDK3Ey1BIRbByjUcELDTWfI/P7 he4KSIC4Yv3SyE46+ByT5tKIBRiH4hh0PHhXZD/rO0ANGVMIGiqXoOQFcaB7JIaQPsVYA2RDs m/1jQLeaJ1IzMlv5d1Iqd6srwzZDbHdo7N3kRb8EjZoIzk8AXb8fG3MkiBEhb5pTvmjBrtLDu t/G5LWm87pHrMBBTfiV1vvV+NO4f1Uu5ekbO6ZT+U7ptDvQeGIy2JtY174CUFJiKHzxuBZs6S o+AoekSp1+0/mkmKB9HbJh5g4xHCWkiqtHeC9F/hHjyNBC0PJ7TF9UNogy9ERCjLKK0OYnjhC S1EwvwPzBW0S7kvYaaFApW4RXanRzjnwXc2XWJId6BReKOTTrgplFy7/6ik7nI1mq4QtZeWPI Y9dAohU+LYpOqaei5JPRSG2nsTkXaXAElDxLgRkDY/C/bORu3egm8gQmbAtbqKFBt8GExMChJ 4/Fxw2ZrgnIWQ21YWcXm8MYaetIHiQZ7dDMMPS77Tp8FwDBbWGzYL0U+jpdmgy0yg0O2djwP2 WSkggHgiIT+dqC4i0rASk+VVFoYKEAkeG+J+M8cWHpS0vMg8eWZA89hE8i5Pikz8J9pE5HTrk mh3UQif27Em85P9RzEJngL24Xv/U5RaXo39rtyYWldJZmmdpLEGSmli3BLnvqDpkQh57lZlz2 mgpKMlI7JFqKQcsLh+BWOffZoPC1SFxc0Hgka//pODlAcoDRWXTj6WAY87zPbMbMhjAqWAKtj nh4ws4mEC2Ew/yw8cgei6jCseQY8xEAeaaC2NKYZtHh1zplG8M5qBeb5qF/PY1PJaX7DB2NZy /EQvS6VPX4Yp8qPxE9gCzbndIuyTJWvPe4+DT1Gb2l+e2gjsnp0LQvDxlXk/X6JUblkPuixj+ I71y3/hxnOadie6/Ztku8Z19HyfJE8f8o4TR+ESPABUrdq7NXg1tTkOwmQ8/gO+Naqn0YOtvg GH7WEe8gfjfz7ZpM4LCMUj+gi4iwhwmvdsTKVDSod3x5iT/wREUyIZlNv1OmHk+rD7HhcFy2K A9aPtrt3KVWVRLUTBseazeFS963M5+zomXF9JzkKUqaIBco8E9tl/9lh3L2oEHKg5U1vfpJ3o DUpEHa8QufQCkDgCKff7szqr2AUjXbdUAcd0IgHhm7yhzrcj+tw16aLtb0OD4qGuN6ZVr1l60 h/bi7NBEeUDTyjJ3mxVP4T8KYl+bB5yzxA89AeXhApmNHPCA0SzJKyD4aZJwQAnu029A9NVd7 t52kgVfx18AAtpbqlg8nEckWFJZGW/+/1MKI4kzZ2PoTmxMHUVZkSbK0Hw77wkjNkWRjTTmV6 iVDgHxtZgqiSEMWmhHk1fopK+RhE2cmiDitm+kfyQp3qwO3I1B3RFqOdegIEjdzmxjQ4L9TtQ BmLptwA+UiqsiGF9Fib6ypxpgvb0Mykhnz8tqSJ5gj2Hg402cDpDUEGTGWaKfcoEtvcMEAlU+ D4oz+KmOWi1+e5oDioGE7Z9bfgm9M1e6bq7b++OT3pew5ofD/uqK3CImn8yUYxFqjrEk5qrxe g/8aa1v3RjoyzE3xTvEGLSakYYJJJAgIStkonBVNVWINeuzT7ghbgtQav9OlO/5Nni/NyE5es 3FUoNBBYdx5lKPhXoZbxQvBj0UK+KkG5uaZLQ4JqKkFGsbSJHcREK4xycWsHkQTYxTieIR+Jt EuPGKtbyj6W93/cFbNrOLthtyC+ipx7xGyhMk9G8IkIrdqp+hJHuPZLby9MiW1kr09p+Q26sv 9QRkCOIy4Ol13sKeTv0vkwumgDMIVCehTmgcehKgPXgHbCxpRQJIj/7CuLpqFYIEY5MfmpKyw xssytsDGEaqHk+l+tFGPKnabKQYA2sfX4rnsAOGRiDpapopPiifYmuF9e5uC5Wwqy4CM8Ld1j WZxk/6QRN9fm725or10YPRcK93fA1f6WsEQx4lQZIRSVaEEws8OOfD9a2HkOrqETef7DxgIBr kvjyPKA/wgS9UhiFKe/WkHDhPs+1LGWE66BvFTsLgfURZ2+vIwLAJx/NUpRqfcEAFHPh23GBf Vgvj2z271czYSUwiAm+VuJwbGDKtluqQjI55eKynPxXk5TS9r2QW/w6WYdCS3P96nDCR0wcWE QpS3rSG0XdEq43+BP4VN62H57++GhK6PACZLYz3W9bL5etA8YZem7rAYXs7JzD4UpYv5yVN3m TFCO0cIduBYf+TUHuAJZkX8emHFSH0jLkvsxSrOdZNH2C1I4flZ5ulXvqEn5q2pV5xeMl9LeS wskUf8ResMD+zc/mZUb2H1+CoAUnTBhIwiKys6kkwXIIkDEq3EmxDZvYaMNJR01FD4ZEYUIy0 wkrpuXLX8Uyno3rlsFOHjdH8ixkLmunkBZwwpDO88XnHAQ1P2MI1pxtbaiH3CXnDpyDteS+2W mOOWpiZl/SpDAjY36MwFbTcShnMBOtOAHkP5pVHMG+KbZxUMh27spnXBu5Yt5QPQMHTfwnSd3 HED9dy5pPuWkOneyU21mnU/aPN0aWwWxcvBD6Qhnut8WIlP6jPui194psn+MSU6LMvTMoV9EA tWkQKVNQ8HNZZfuB3GV7csBlC2x/nfq0GR/OfJ332EAPIc22FD93zlxx0WRikoLOKJrlRuH4b LOFGc0TyBS9KSr49E92CVqKrhiBKWqGnmf1wpxgCqGGLTkzTsbAMYvbGn3hP9/2BQHgyxemfI F0bDYtVJrcCwwnACQTOx9RCLKeuoriIh7K4ne4IevmLWYEeCXG79OwaGABwYd+GNtrE09Ix+T r7aNhqKjcWmBc/+dH5qwdq9I2LO8OxjBeuSS/TIgMbLpgOTvV/wCfLB+L4/2Flw5COn2v4NI5 qEFUSETPWSoO39J1H7Jre4aIvlaYAfeJQ411ufVRRcfk8O2rTOtb61fkgWViLPmFN+ZxMpy8v R/gXDuLdm84DIHlA3AhyJqgFfMYFc5FnWatqFYlaWUk+S4lYRU7UYiWVp7AKzorP+gNUEJrCm i01UrbP1x84r2tk1DzgDgvWvugumtdmaacTrMtKXu9JWZDdVO9jXcSBE1eNzBnLOWoM/yhsIU C7vwg/Y0qgDWS0KGV6htya9G219OwxTgRbUi66rlFtXF4z5sg8GLDExCJg0QGoj6PzOdACCe9 H0b87t1XdxBw8ZWLo+xJNL0aT9oO5A4IQfoGufCGCelW1FurLiUzdpGhZnY7DJ7TyGExXjhVF HGsl0IYgguuqErmWFonsjtewn+/DI2gNz2rAhIfkbZGn1Ub79hRIRwk7WJ0U9TTeHkJEd6q28 mhM3WxtT0DH5+NOfIg50HjLVxNn8Zt1WY7Yg4R/kIuaPCvKc5fJwpfnMZ4W4UvNGFdJ++I15c 3U+IFXDMqC83oGjmC9XDYGWt5YF/ai+ySdfTUwyKKYBE1e7iMEwGCPBrQ56eZNZO3addfYgPA kuPZjk6AQbVuvb3/r/UA86zy1M07p1QKMokk0rdgLGMBS7u8/1Oyskfs9jvdfW7WedpyNfHGQ LF+xicx5ZdGxu1zV+w8RaI3ZfgeK9vGwEJ+vOFZpPfaDMGnLSIKeoFtsFQFYlVgBdBQ7Z8E1k chAFaM/oeU45WacU9CDNXJcGn469z/MKUIdHfjvkJtq1mzefEYoWulOhh3Gb2TUJYZXMU80mm RH2fQq4Ina/TSH/eFr3f8eV2DnBDnSrmlWxLVgGL7mJ9KolJudRGincLje4QZto8No9dvBS6Z aqjIKgSMMMl2PglVXm7ocmmZunUvtbKInZsfbvEJe6916P78lRwZ4m3NCwgBAscXtMz8wqOc2 fk3vnQZWjCyTiSIF1667T5ewW2WAMmv7qX7jvtyNDzmdhocPa8Yhmg5f1XK657b5RVXpMuO+q pQAVNO2z9lJacrqF2sdIimt6T8jOxixfixoWorJ4wZAlW5UIbVA9q7d2wSRXSVPm2XC6zUOSq UdvtP4aCx8tlshsN3cPizSeqdTdYeT+W2NK22fraZRtZVE6aq1Td7skXjHyGTZYyirpdAC32k f7SdoFvZkiF94py199bEu7zt+K8XGbNt4oODYYTLBuRrPqe+lTliw/J9dtda0i06axy/rAgzK S1c6AKeirXBVQq8aBTnmODP1p7qtEWSHHh/6f4+DXQhagt8whNORt6xMGzolUO20meeiVVtnL wOzBoPOYW154d9OtInqkunEYd06a3yyp0Dq2dG1UwYaLRawlWrHumGI1n0OZgU2KMb0nh24os FPgcQw2aCgH/exRnunyHovfyNBa9pJU5x/xwjdDr3UPsA9Ca42O0mI/bGGoTNQkchPxqOOOs/ voXcuIp95h3eFaDBRE2/i43ZPKWaQtlFPWLR/HbejPCb6VFVLHjCwrRBQ5YFFWnJHhAJWiDxa r0YMGgVw0ZmUocD0B+SN99MoD/kvpoK+r2CM23o/ZSdEycE1UcGkUDo2G4RFY9P5BN6/tckwR eKJyx+rfnVw+iGvY8pOCW+DZyGXtR9i1cDh1Dsj7s5TZypMSsK2KD8O9QSegoOWyumC5JTEeK wBgPVAUzNdCKkpCphaStSiCW2xQ5lcQaqwW/0DNFmNqwiJxRs5p+6fEWs8b2iIX/i1JlQYTrJ xtsvw7pgTVWzX9bn8dB5VIdcgti3jYLdiEmBUnuy/7payXpV0VCe4bleIyPkTJdpb7Yl/pQom WlSku723bvlsgRMpBycUwLR1DaJaEm6ZKUVQls64DyFdPcNsJQP6Zthsc756itlx4DAMKHNDd EO9z2bGQiARx1om3dEn/na4pMeoNYJHFxZHshIaIPgLS+/pJq/qstNAZvBpSH21GK6qiq7vpv aOzUNsx2uW5abz0WVuegS2oE8cVgxGOJsvDCTvfNUeOnyjHvjW0vfPCQrdLnyyg2DmA2T6RTr 6oeiD7Grf/hIIcvV3gcpVqqngVQJCZyzlN499CQ/4bb/tJzA3hvLMbiG76Unb4mD47otSgJ8C /If7pEDYVHr3WRLWa3fNG933jvMuIxKJRVp7tS18CZbylEuXex1Zgsh3GXzdISJS7RKvui7fZ olSHgpSjDFaQtf2GIrEDgxSJtpinWly8vw0oxb List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 24 Feb 2026, at 12:37, Attila Soki wrote: > On 24 Feb 2026, at 12:09, Andrei Lepikhov wro >> This update gives us more useful details. In PG14, the join search = problem involved at most 9 relations. In PG19, the maximum is now 18 = joins. Do you know what your join_collapse_limit is set to? It looks = like subplan pull-ups have made things more complex. >> First, we should look into any possible 'rescan cost' issues on our = side as developers. >> On your end, please check the join_collapse_limit setting. If needed, = try increasing it to around 20. This might help. >=20 > join_collapse_limit is not set, so it is the default, 8 > I will try if something around 20 helps. I tried it with join_collapse_limit 10,15, 20 with no success, but with join_collapse_limit 1, 5, 7 I get the good plan. Then I set join_collapse_limit back to default and flipped the plan = again with vacuumdb until i get the good plan with the default = join_collapse_limit. Then I tried to increase join_collapse_limit until the query (or = planning) runs longer than 28 sec. I tried 1, 5 ,7, 8, 9 ,10, 15, 20, 40, 100 but the query runs stable = with 17-20 sec runtime. so there is still something weird with the = statistics. Now with join_collapse_limit=3D7 works for me and I am not able to flip = the plan. makes that sense? should I still test with increased statistic on table_k.dp_end_dat as = Laurenz suggested? I could now share some general infos about the query, if you still = interested. thanks. regards Attila