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 1ve165-007tJm-0t for pgsql-performance@arkaria.postgresql.org; Fri, 09 Jan 2026 01:15:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ve15y-005CYi-2k for pgsql-performance@arkaria.postgresql.org; Fri, 09 Jan 2026 01:15:19 +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 1ve15y-005CYZ-1T for pgsql-performance@lists.postgresql.org; Fri, 09 Jan 2026 01:15:19 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ve15w-005Ngu-23 for pgsql-performance@lists.postgresql.org; Fri, 09 Jan 2026 01:15:18 +0000 Received: by mail-pf1-x42c.google.com with SMTP id d2e1a72fcca58-7fc0c1d45a4so2197198b3a.0 for ; Thu, 08 Jan 2026 17:15:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1767921314; x=1768526114; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:content-language:references :to:from:subject:user-agent:mime-version:date:message-id:from:to:cc :subject:date:message-id:reply-to; bh=XoRkyqX6bsmJZQ1W5x13LF0f3PofbbXZL1+zNBeugmA=; b=KjSRXXcrXZs0LulFJBPqCOI2hiBBZhzpgQOBZQsJRw99U2davbEifpZzPL3hYWjef+ bY8FNL5wlP1VWxhFFt3B2wuQbhsc2WlrU3QwaxMyiZCZ5b9iH6kDPdobpoEUVEAU6ySA VL8dcM7uUgmywQgUsmVU/c+NraK2MejHe5sY/jAG0sReIxPdbSMgp6wsh3I7jTdwWxux tDrdZuH83QKImMGq4lKvvpsd8PN+UeZWIE1XfTbCyuceP+P7KagAvgkqRm1pHiSYSS1c DCV8QEZOO3RVxq8vS5SqqMhhyo9HXgpUuN5U2Ysi5HqEbcwSOq300oO3rPxv+ubw7CdP C8Ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767921314; x=1768526114; h=content-transfer-encoding:in-reply-to:content-language:references :to:from:subject:user-agent:mime-version:date:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=XoRkyqX6bsmJZQ1W5x13LF0f3PofbbXZL1+zNBeugmA=; b=X0zkdSqrVuwyXr3qa8Y9YdrER7P+RBEtmLUfBLjEMIgz0VZTQyU7B24Pyjbjj/tm4c 4gWs6C7rPG+gIf4NCjyQSPQhWdFqS0N+egrAyWvD942Q5F9JNLE6YUA+O6l81Rgq3UX/ 5fNslh8386lk7pmy+biv/fuvGQQqXXkpBcKV0wFnUoDd6abSdgIBUIgzK+xvSMOn3FwK ar3bsVLrajHYoPT3u71vd0UdMgrlsrex0EK8ZoV8UfJ92LvfV73EfD2ULJqWY4RiCWh0 PuK4I4BlPxlqdpLX1piZWmc608xVpmxJUuJ0EK3co9mQEq7jKcNRNnfEXny9UbMx5Unz lxsA== X-Gm-Message-State: AOJu0YxxLLa2rXITiBGiRGK+ObcBRZ81m+7alaGoIo6rYzfuEg8KJVWF vhtkcI+y7PHsD1Pjc+aT5xLFlys/C4Bx1sRRhE9nqa1TvnfChpqh0YNNXP9gng== X-Gm-Gg: AY/fxX4EbgQdpxoUlqRSB6g+iwEyL6rN+d09+c3EkkM2wxmED/PXkUsYOX3rIXG1RwT i4ht11kwwR0WP5sVDw9t2cEyRJ3en7fltiwhgKsLiH+YLN9tPWGeXrCluBm/hftrDtNIBOYZHS2 CGOTcPzhk5QpI2GlsfEbcInVtmx2wvoLEoZxAPsZGUwlNMx7/OfP4vGTMxT/MgVO9ujaxS4djSi h7e7elBn2FoQ+WwJcrujzXgiuT5gKQtWEJkRi1K6tnBFg6fOybmbFogJ2OLZQEtIh7gWFAqku6l Q4g8cStH4+52tvOjQLaSUdFkvJFgZbCbHzdtxln3WEYLH38yPoY+roIFa44YGAagZpqHYK2Hbza bBYqWs9A0Php/0g9Q/mMfBTJDZ4cE6QpHBMnKnpilNg9eJNR3gDNIYQYz+yJ675M5tb/IMfYFIS PM1KJnvguJsGaCpoD49gWzjgoVCprxXQTOe006JsM3Go5dHGnkKwvtqPj22hY9BqLv7DmPrwsk2 j1z X-Google-Smtp-Source: AGHT+IHKeg37fY1CxAM0leK+dl4GQenwtn9aGOBdOlHRqH+MKL74vyEtSrBtshnTGSMjmlkCIWYMfw== X-Received: by 2002:a05:6300:8b0f:b0:371:53a7:a4aa with SMTP id adf61e73a8af0-3898f9511cfmr6596705637.29.1767921313684; Thu, 08 Jan 2026 17:15:13 -0800 (PST) Received: from ?IPV6:2404:4400:414b:1700:b092:c6d0:7613:982b? ([2404:4400:414b:1700:b092:c6d0:7613:982b]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2a3e3c3a507sm87742335ad.3.2026.01.08.17.15.12 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 08 Jan 2026 17:15:13 -0800 (PST) Message-ID: Date: Fri, 9 Jan 2026 14:15:10 +1300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Another unexpected planner choice in simple JOIN From: Mark Kirkwood To: pgsql-performance@lists.postgresql.org References: <5874da50-c9c3-4e66-907a-a5b564eabd85@gmail.com> Content-Language: en-US In-Reply-To: <5874da50-c9c3-4e66-907a-a5b564eabd85@gmail.com> 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 Err, make that 19devel, sorry! On 09/01/2026 13:12, Mark Kirkwood wrote: > I have encountered another one of these. However managed to work out > what the issue was myself this time! However I figured it might be > interesting/useful for folk generally. > > Same schema as before, with a few parameter changes to 16devel: > >