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 1vuqjO-009aEo-0q for pgsql-performance@arkaria.postgresql.org; Tue, 24 Feb 2026 11:37:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vuqjM-000u0o-2f for pgsql-performance@arkaria.postgresql.org; Tue, 24 Feb 2026 11:37:32 +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 1vuqjM-000u0e-1U for pgsql-performance@lists.postgresql.org; Tue, 24 Feb 2026 11:37:32 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vuqjJ-000000012fH-1ZBc for pgsql-performance@postgresql.org; Tue, 24 Feb 2026 11:37:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1771933048; x=1772537848; i=atiware@gmx.net; bh=j28gtXfzd0E7h+ov9WegRF8IA0zMiIOKwNRoMlIutzw=; 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=c5UO2O/7lnTB7kzT1KJGtdCosB4MZv/0DT4ziA57hz63haDBAqKd9PjiANyMfupA sMbVohAXN4AoauoxQC9C9EcC+h+K/rxIBHgWjoZO9P3WAuF+Ltpz/UX0KJ0+PoPvO fbkHEyTy39YSkDE7nxuv7yN0c8yFqvNx6FqT22tNH1j6sPdVmNHpUweARKCIJ1JAq Oxwzg8h0k6RfdozsZU8em5QVB5McU1DTLEIFCflYwfegKjh1g26G3zZ/nrRZ9M8Be LJfOrpTu/Dyl/FtbjqoJ87F9sW5XP7AG3AR4svAlDxsmObC70nuZj+ZZkbIY7PzkC jlom1cn3vKRjyKGXjQ== 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 1MPGW7-1w4Xso3ouT-00UwwA; Tue, 24 Feb 2026 12:37:27 +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: <0dd76506-053e-4a30-9f95-9dc324e8e1fb@gmail.com> Date: Tue, 24 Feb 2026 12:37:17 +0100 Cc: pgsql-performance@postgresql.org, Laurenz Albe Content-Transfer-Encoding: quoted-printable Message-Id: 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:XXGwOMWH+irJ8jWsy2S7EslaRUS+D0ocrE2Ld9troPRpr7cHChe Aga6qqYgsUUxyEjOVXJSEsK5ALrdMqlaDcj+wUFyxf8gI7+XedWQMTzO8/qVAMbQaOJrXBo Hlq3wetFuTLX9QFbsk+pJvl/+MSZe7TsZXiipLX+dvbhskxcBVVry+oZFh2B9fg2L3CVsYt Cm50JvuV3d2gHwRq1n34A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:yChdSXvH21E=;h/HkKw5M7JxhDSCEivi+GT9sNPD DU+uldB52UvVO18fAKYrk4WUyjNnAHzIZr7K0pveHsdMw5hysOsrA0bwTxq2rYGlWw9jDAI6l L4KO1Ibl+ZQosfsurXCV/cR8MONbbmkdZOtKr88fF7/poCqbmljKxkGal6BGS0I7tfVkzqhdU rfJWzHUxz698jte3uisORCoM5QKe8lN0rMc5peLMPsy5IF4bEAIoX93rHNcoc1S4XycixoxJC QYpScaGt+MAtJCxNDvfZa6vtYeH0ByZQqEk7Oj7wxX9DVqE1VVh2eSo47BTOfGExnUkXnaXgd ocMt6UI4tvfdnAFo1ii+zuirohoYH/ifkaRO5pJypU/Dcfnn8kYBoS/PvOICEgY89nC/91nbz 8YtEIby4u8J3T8dEKi5TObE1lTjwb7mSpi3XzV+sKhAA2TdkPbAQ3efe6M094by41OaPeuTgv 3J0AUQye7tqAyVUlE9Yj0GxpAp67P8pe1R1BQlw3Pv+UzYi+OVoNCdfxPj9JsFwHn/lAR+XAS UZZsE1w4sY5xgmHDhZCZLz/r1Z78s8BYA5pAZmAzwDE+onEVUmORcG9gnMf0VcyKujdVDBbxq lCkDgPYCAaHhIKvyDEI/VdrgFiDQXIEzMQllcI3UkE/5BxV+vXCUwnS49SmkPAMIkyak6GmzR CgLC4J6aVpxVSl99NooodXBFxl4vFCy/Aq1CkS7IWAj7PnSSmpf2BZcmY0ndYphRhsvr4cE7X GEgeefSOmrIr+ilKHdqKBeuyGg/Q9H2e+kFqk2AMqjMuQR5O4M1Ku1Kz5VGPrNMSWGke+fKCN bpDt+2SwyNnAax2pLR5hheRNOzv0MIzeSgXCDm/Se48DBZzzulGwsYTJww2QIoyWU2Bo8XIsz EEATdoVNS6vqt9YZU6pJ+Yid8VlxKrfklrqgzg8qVd3mYWLtAnErFiD0/STOJKfX3UlhQWCHl UftbpM4kSsDiS4EYyNlcTf53hn2oNAkIRBWeq7rI7U6LnIhNPVarmpT6tHuwTkbvvvI25aper MyeR3v2oaufkSa9uS+Q39vhxpnhaPOHqvbOZ/vYEZQtfIbrTuXdC2jBmtoimnbYW24GPrWemG f7tdfnGclZqUXT/XBXCe1QBl95WM75XgrU/j2d9SGwOxLxiRKFHBGuxam3CpVwe4/0uM0ei2F vxiMTSxXBxkIKb3u8nL6h++ONenBwBAHYga5yaLBDPsnpK0uy4JvGE64kvNpKjpaFOgwBlVDf XKrEFTvFdx1n3ktbcv7QxBKk/fjl33P04pDhfXLHFYGXEulstEA54Ra507QOekBjOc6fnQG1Z Zt3G1QDQLIXN9IL3mflqbTigqnKhWVCKkd2/1oIfv8a4w0Ylw0NbpLvQWJVSM/dNql2lKR3ii GtwHU61HKJGonhd2sNQOcglBOGe3gwzahDGTN8j4Av5q6LFHaio/gXVbreIEBQ7FYkCfokMj1 2EV2MA5aRrGyFe7t/yweoIRjPgW4hcpLm8R7zf7nuT6pIdVpQP8BMQumoT0Iz089z22qjupY0 LEzDPoOowT7k0Ij/p1tGAHg+lbq2xtDWoR6OowNhcY6IUFCpyeBbl7MIqXkniIiywoAyj3Bwd TBGfNNBk95sS7UFoGWAvi5avcusjbnuEFa5q07MfcqalcC0qRi7HbudfZuYXi+Wk1VUfuHYaJ cgu5q5kQaJLR5d13YgnrSMNlxgMEKuWIwqDoJLsKBiNS2NsauH6GJ4+sVEfUqr5KTc8T1vn/T S7RWWexpoL//H+K5ygWYfJfcGkJdwaxjspDr9fWlVX26GjV6IulMXQZx0tKfk2NnQJheDV0rO Z+aK9MA9U6tptdD4DddFW0Y+tZdBBY3xrBci1vLdj1yWDkkJlZeJgdTkvZVgQQAFoGErVBgFH 4Dq5UVww+Af2wD825RoVG4jircitp9NtZhzpmeMguvZdsX6sE6L40WGF0N5XGYpbn7y2Hy/Q2 41pg6EMtv8QvJ3e1m3tVhp303pLHfs9cMrhl2e/n5pxd4p6DYVeKXOEPhXyoxfgw2ClliLnMK U+OPL8z1RLy81qhq3LEmWsBa19xLmfLHsT9NelrGkCJW0TqJ/mjOvCXAiSvPEAKoWL+F3VBqP T/jc/yqQzFNTfe/WTLCB0XxPU3LwM0B0K1ekp9OxyVNIVP959chnxT2PKYb2kHmXjbj3TAmB1 GcVAAiCd9kKeABzivV1tvL7034YhiKQfIpYwKQpFKg5jWwDxwqdQEIqN0vJtb/eycqbwnoM4r KY+ixnd4lJWS9NJQyQS0qpQ0kZJKQy/ONyT78Q/cjF3qUYWMZg00/klv3pnfYK97dd34Lnroy /eTzL6YWroWYt2gtkf5w9H2Psw5tUDMVoZcJSwJvlhNv8oobnm3csxNfKd4TRu0cEGMvn0HlO OOc1QihxcfkAcLDZ9S01MS63uglTAnWQEvliLFUClsw4W4+72JKKL1O5KUYaLXgBkcN4Sf/Tv DCZ/BnX6bpoOOc4+rZfqP/1mrcR6qXMPtw6PxAbOUxtYyykL4m6Qi3H8asFsXcbn5M7XfBydg 0lYcQnwLuBcWDKRBt4YOZsT36OY6aDKIJa2sxB3DPw9DPintvFqD/SzAy/5gC4BUG5uo4BAN1 qZ3U/I2bTvv7TgdCd0iFYPhuo0xEfnNO1nLj5wZzSz0/OmTgVhuFSwhaF6BGQVf59oKBzYzpc XooM8TYpwBoZDn/PosnVVd4ab84QmHrgRp7UYFgJ4c4Fqe1nvCOYn05C07QmIw+DIElDLuv3t hINmQIPv/orcQjIJ/Wc410Cl7Ze9ikNTxVxTVkB5xFrAgHvR2k/DfZRcGYNAH3E4BzgiQ33dI gYJnsqi0LBOt/o+ye7xPOIX3vCzJL1+/IQ0qRxirZUYx7mVLhfuKkW10RuLeZtSQfd5vmccsR rQKwjutOhMd826hIJZs8eAj7nOq1TCZSlNx5JmBIM2CIhw4C9E1zudZuZORzDVpni7r49CMOz pjoNHspe8Uvb+foar03eHQ60/iMpP54k5ldn24rd0OFOxxCL6oIIh6QC6hrWULNk6mjldDgk0 /MR9ocVP2y3cS2KKiA0VVOXHjvYHULR4CiT2WckJ7nkdDqhpuVQy98Kwl9WWjWbk1EvBs4SC1 442yHligWaq22GMKqTtz0nU42Hvyfs0pjwlTVT8I25VncBm8HVEv9bxniQFwSCO6YKc9SJ8O/ WOMs4l5Mk7LqNX88I2ihae75Z1cjYpOyh6oRQe9ULQiz5sVMCvd26U+flKq32F+h6GcEaxFkG QfLxXK+IWcD5EQAalYBjxbbG7fv03usH7fiWedTCrCAAIxZbxlaEwDGlO8BaWM3NTRX1bcZLD 5vU6P0GIN4FrVTpmedtT9Y8iBOyNtRXhcLFTO9ytkTXF/Y2IsYy93VthQkPJYXFBJ4fNfJyuT JPNwUFLGToVB6HJygzkjwSEFWsVX7Yi9IwWKKmmcKom8XITPhspMJb/p8Thd3pgk4sDDjTgBl S8wjfbN1g2G6V8IY2gM9RQCFDWaUMvXjKmWY1LoQrSZ3iNcPBU47k1FZ0GigA4sUZLRMWosv6 BlueCHW1FnVUEoFTK8KwAer0/1M5eDU9VVTTiDc7OD2btkravqTSp65rmcc1Vy2iGGzYKjyIq 2Pqgh/WYtiHkuALehEdpK2+dJ9HNx5uEU2U4KLTIr06opsPvYoRczh+jqnMxifl1sGNO3aKmC fSTqnHisrgAKOS3b4tqdhtuLpOMm6iUpuQY/QS2uD10+GDjRaLd2FmtBg4DqcBW8tPWBdeYl9 QsVgs5D0t3DsZb0FVAe0UzNtrNZg6IWZtIXa9vl1ZOLe69yzLFZulEYoZAcNww2PaFWf7atAY w2hUQGPIfkHrEoIkhGzsmxZ1MVVIdEd4Jp/TMzgTJtCUMDH4icLbl2aqbdTWScZmEROdWWVLk d8FZsL1EGfe9d5r8vWosYncpHH1EyLPcYzQYlBw4RT/LYJTeMd8Tx8IRErYU/N8MqfG+ZjDRy bB0OkLP/CCw+5B8vYb0mwg2uBRa0y/Gbev9SNeUpa4xqy4/E37cWmj9rXmGbivspEra+e9UF6 jcxJi1Uos8YP6mNeqaeUxGJbPKvRijVXO01lPCIsFaY8vT3cJy8Lrh9VPmm3bTP9RujpomuEp AN1795jStu0emtceptEG7BVqGa/8saNx7DxJDyrbNT6WNLWaM7veezk/ReN6JJ0SBFaVvdIL9 HvGYoZ4xk4tmL72oaPNAw3rRSX92X1hpS0magIXvN+pB/6ilm1Jl/5BKkTZS96O49ryfjAfJ7 wPStF7oQXxvlqUcWMBDd2skPIVcrgwo757S2DLwk70eKgrsgotx1JxQv6Xkmxpjs8IJTPgPti j4rnAq7RO1HPy4RSKU2GhD6AWNIrTD2udn/9JFEVApb2LZllJ5xSLCMn3PYRNLy4Rw7nHilFA dLMT4GkPBu+ZeFIvz/Ei97dbQIAVQh3OoQZT18Y2VAJM/3oWVESWgybzOIHEFbR6greI0wk26 dsG/l0vYZ+C8xwrOVujmQEs3knb84KjOc+xysGHto/DgFOfPGwJTWx5mYPUnl65Xwd/JfLn1M duXf1AnkFQjZ2QrppAyVgN/sDvDwPGGuXZWATWXjGBaHfzBLgoem9xeWmQv+xO1V4kgLCVmT1 ig7ch2/09hB5317jIqzTkiMoCuWNyRc/usNLd5AmZG564tD+hucy1JqxfhWpy0AHZj+qoqyLh 6Rp5kxLs5c8872QYZ3KkOkaO6Oieh/mX4zipH0EqO2NGp6PY+zDy8Gac9iq/37onXbs62MISu vzSC5KRXsRK2nTOQeKLDu3OT8obVarQzu64Bv2JJSQYug53BIo6H3AAW4tmEd+ynJdN19n8Mf Cf+YayGR2Ic4bA69UxYbsrQDGbcLXU5YV1CI3XWe6qSBRpui9MqI5KdRU19VvZ41IHxwGbKy0 z2GjjpLtOkxiEofSGIL8QEEKF98gNujRrOj4ekFmTYy8ocNBYKPOlc8svZH1Lai6yX4i2xdth G8I/HSHSPvFWO/BrkBn0p2HM4b1HDuuBmrB1coynz0VE+iGYnCMg/thgmSmysoqEVAEGy6C4T Yawt+IPiTQe82cyYZPHq9/b8rs5QO/aq1kO/87f782iz04/0GS5GCl/mF5dz2Knf7mhkhgucm nVSybAxobWOGmXhM4= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. join_collapse_limit is not set, so it is the default, 8 I will try if something around 20 helps. thanks btw: I working on providing more details to the query regards, Attila=