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 1vdh8f-003ZU0-0V for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jan 2026 03:56:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vdh8d-00HIme-1u for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jan 2026 03:56:44 +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.96) (envelope-from ) id 1vdh8d-00HImW-0k for pgsql-performance@lists.postgresql.org; Thu, 08 Jan 2026 03:56:44 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vdh8c-004p9x-1d for pgsql-performance@lists.postgresql.org; Thu, 08 Jan 2026 03:56:43 +0000 Received: by mail-lf1-x12a.google.com with SMTP id 2adb3069b0e04-59b6d5bd575so1878817e87.1 for ; Wed, 07 Jan 2026 19:56:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1767844600; x=1768449400; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=029Ke4SQiz5CRyOf7/Rszfn6PR/MthzrsEmZ9uHta1Q=; b=dcXM5J/F+11oqFJe25rgMcelfK6UoQwLaIaqoyg+qxet4LhnCKJC3AKUZ1ug9romJQ 7pWY4DXGQ+x5938pCBWyuLir8AkVy0oAMSNUvNJDdnOFLmNddPaiPiwdyKMAic3Y6U0t GG2Jp6gQIig+DzM8h27dMJ4jC1W7t77tJlKAoiCPe8xH96/+QciXCfIu9Jb3Z8e2CsJQ pWi/jNqEBKx5IF+9Doy4IdXVuaNWsPbxnLzNpRXPyquFAnhVoe60cC136noZvGjD0qYt t+afGIaDDl0dcglA8QT6kbJqG+IHmz/v3eozSEk+F1h0YYrhSg7WhIS16LoU8HuGeUHx WDUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767844600; x=1768449400; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=029Ke4SQiz5CRyOf7/Rszfn6PR/MthzrsEmZ9uHta1Q=; b=pdhKp4fAHQqSOhz/zASIw8pqOy8W2jfZTx5RKfvvEKgPjQT8oOvbmkySogRwiZQqdU i5PWfcv+O1lOKNoweboBB9RPFA1fUwAQ4FaOFwc6Wnt92kNf3crInrrP62QxliunRyzy XakJXBqF81X81Q6LYH22/Rz6kIG9QU8E6Q4NHFp6pGUOaYvH69ML7w9JyDWTQGzcg6gz 3emxZrxQn/Lv6ZIjC7V0ZODeEpjyacoMfVs9PkvYbhtrfCDgsD06KbjigXUqfW1D7Pgj 9g9rR9kXTtf3pCldv1x+SPQPXlAPq4/sxTdSJMKqnQlSCXURZtPmS5DpkCwVA9KNi24O 0FWA== X-Gm-Message-State: AOJu0Yy/CueGi8+cSjKvaIl3kn3zvbzMg/0fVHM3GJp1WdBxLJxi9oTm M921ROPXEZw3tvwxGRxbdTdvZQtZcifx/FkYU89jSaHngD4vC/yLBrPa+EoHJ9gY1+1OgMgFWLV sYLrq/EjEPQ57rFyaAXCBpERzKV8Gh1A= X-Gm-Gg: AY/fxX6TFjJ9f7Y7nc/N1Mu8WsDyhbcxlv5P2GvA5XF4alpG6T0KaIyY2x7EiFiDDeY 4uyAtJjVKqUzXIgVTDGZf3fNL2AB6sqnzzcwF5k7wNujk8cmeUKRC3WSQoO26mKTD6OXG46hPsk A2KZfJFYT9I2RFGoekOMbmVCYaS8C5hvhD8JjyHNj+NS+nnuX7+HrCtxW1hrWt+oMK6kl5EzKjM +MvOEbALJz53lwKnoCE3Lq6v6w3/HliPC3zzTVxLrIgimEB/YHxEuu+tonukRMRiGuhdklqtwWM G7g2kQTEDr40GBZeuEG+1Q1Tkl2TwuGCiH6EaY5vki1BWjdPNOjKgMr2348Bag== X-Google-Smtp-Source: AGHT+IFNZNFfPTaoHX5j1xNf/fkUZmmQDxXDUGzcBolfdT6wL/RhilUdSP0If3ZY9rV47BbjPtZ7vTGXus2TsoEWjao= X-Received: by 2002:a05:6512:3d05:b0:59b:6d59:1e82 with SMTP id 2adb3069b0e04-59b6ed1343amr1501664e87.9.1767844600123; Wed, 07 Jan 2026 19:56:40 -0800 (PST) MIME-Version: 1.0 References: <71afdb09-0583-4af2-a3b3-50da4f987b9b@gmail.com> In-Reply-To: From: David Rowley Date: Thu, 8 Jan 2026 16:56:27 +1300 X-Gm-Features: AQt7F2p8kpOm937rkRy0zqvY08eBgVezspKufFvarYTVrglewS2TBvANiugDjgc Message-ID: Subject: Re: Unexpected planner choice in simple JOIN To: Mark Kirkwood Cc: pgsql-performance@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 8 Jan 2026 at 16:34, Mark Kirkwood wrote: > This does seem to be related to parallel planning: Isn't it just a case of hash indexes not allowing parallel scans? David