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 1vlF9n-009Cts-0y for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 23:41:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlF9m-004bGS-1F for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 23:41:06 +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 1vlF9l-004bFJ-3B for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 23:41:06 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vlF9h-00000000xri-3VBU for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 23:41:06 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-79088484065so3617247b3.1 for ; Wed, 28 Jan 2026 15:41:01 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769643660; cv=none; d=google.com; s=arc-20240605; b=kZDY97OARsl+mtkk62NEjitw80NXcgmQ1rWkXGwO28ypLtl5vWzFmh+4va6ZlRrtIa 3CpEybt3z5POHQdcFpZN4msKUgt2Q+4lba8JfP9hic02pd3vb2Ylbd5wHJK5PZaxkV7K BtNHtHyjhq9IaoDhFgRenywb1CMLjHwJ403zdyaWn33CpTqNV+Yew0EH+fzCSr7zHts9 bfauqv2VkjJRGNFxbmAmO9DIHcYYUJksnAGwnc4aCDKdOx9Z+N8++k98gCuHC0ydDS5R GjAosG6i+doqDaOR3B0LXxuNbDnJWlH/+hD89FMkLgArYL6A7+N3C/bTV1iDZXDMZEyj mOPg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=fTktTQ7I6n++hx14oop5Vo0MJQq8m6qKSfHEVeWCHug=; fh=2oWegJHpiEN8v9G18IeI8FVJAfmzUwa8zzysqtLvbAw=; b=fvXvV9kmzOeYRFl9PjSPtdhUZBd2d7KcZGMu9w4+8liIRmar4o8vt9uq1Pq2PT8pKp xvPUJJWYNfB5mQm3Oqjv09DXKYbZMhD7VB1SBAqcYy2lp4PX6UR4L+TW8xonLFZX0dZf Q/q3sIPSniMw19QjAtIEM2o8VdmgRP42CgqKlJbLXd6LWnJTWEa6IV3+GzgsdJpaBzor TQ2OhNQ1imit+c7KNWm3j2FsD2QYYHWAAEzE4CGkQTXVJqMsMH0FowErlrCUctRvYt4q zvCdzSNFuWOiAM+bEwhB6BbAx5GJJycnUxoq4N8Fpf5GxqKekT+DDP+/4FPp78MeTsC7 Dy0A==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1769643660; x=1770248460; 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=fTktTQ7I6n++hx14oop5Vo0MJQq8m6qKSfHEVeWCHug=; b=Namy8pGuv8NrvTz90ZWL9xl316odEeRIhUzaQeNA5VGrB/0YqErs3rU8LPAJ7EQtYD fKdsTfoFQUqN4vw1ZwS2QtpphzF1b2UUyIAdFtr64jReWeLUnPYF23/lhlianc/A9gw4 5j6MkSSBdaNhqaF5zKNbMwBjgUP6hXhcjtxas= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769643660; x=1770248460; 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=fTktTQ7I6n++hx14oop5Vo0MJQq8m6qKSfHEVeWCHug=; b=LR9CTEoWkj1xDn64p5EnyydLX1vYuPHaFxcC/6lxl7Vj4lSDRArdzwoomFWgf8+AZT 7EGygu5ZqAP+7f5syXd9vGBUPBs7AQaDJvIeu3JIc+iFmYk8KbXSBUJF+Py2UIw72byQ LpXxQJlSzp9Agbi/KgtWJjoQjxIAOhTvH7kJa18+N2J0bhRDQy3UsDJYHSqEjAdes/Cg SRnKPzq1J0Td8c2uS/iDU983yNgMZASqzGPkoCpL5piOGmufaxN/MXACJzU3K1J7mvfm dEGXkfAbrAKc4J/3Q93qh6jDCPYmLNO+zNx3IXQs6cDtG5MhCLX6jMJrCUOXKzXHooWa 2rcg== X-Forwarded-Encrypted: i=1; AJvYcCWDKuHAo8Lk/gS2RkFKuuv0NPA0FgjR5rCQfyXik8lZ+DRniqJ80XKv3ZWYLRGdfuTmfBkCjnfXXBuRkF+y@lists.postgresql.org X-Gm-Message-State: AOJu0YzVm32WOhdvqvWtmyoeGjpljCebRp/69sgviY063N65/q5x6lLk 2sLssO3cKi3wyrnsGwdXgD4CzbdRvltzLeEAr7JpY2xebsCXNv1i4i2YmJlUgOT2V9/XKXAjFkw hWcfaUGrJeHu2F7MfheG6Ruth3vSNAua7sg4kxGI0jQRR1Ol6bagFo4yPD25WGVXNy1lsz6R+5E 6xrdQVMFEArGMpQpHia/fp5BpmuwU36kP9QKHAMqPPXeF1wQuzz/UxdHRZ8JkeshK8l18Re92J6 awyeyV4ez/2fbIEs19QmlqeppMsbvpm4rKlKSeKE8m47mkz8dUZHVM60cYfHfy0/jE= X-Gm-Gg: AZuq6aLapmceVIhpZIZ79bjbaaj7hP/JPPe2dg/ffQ4c6qzOjypfmwPo/EmyaGgO2E8 pkiADxeGOtvz9Q3IXDLckc97hBUF98kIx2B6zkuTes1yOuTgKjqLW82MvfPsQySF6QPmWpB+Vhw t/iyYgpSmY8hL27YcPgnjUMfgxfv0p2qmlKwVdgfrZHeZ5Z2ms8epXYfM3i/9taedaBC7rOshYJ dmKku/W9spwKAQlLRDT083+cHT4tUfZpIX4HLnYxQ6sqLiIvFyKFdC3vUjmX21mLea4xpLz5xCi aiD9Dv0MotLyDY0pz/UV+EVx5CLY8XDeASNoZqqILamcKsyuYFR8QGOB X-Received: by 2002:a05:690c:c455:b0:793:ef21:d369 with SMTP id 00721157ae682-7947aca6740mr122234227b3.70.1769643659745; Wed, 28 Jan 2026 15:40:59 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Zsolt Parragi Date: Wed, 28 Jan 2026 23:40:49 +0000 X-Gm-Features: AZwV_QjF5iR6Aab6rEmgq_iNGyUttn_NiP9aKSbbam4VoA4BV0qevHQ4-VbSFm4 Message-ID: Subject: Re: pg_plan_advice To: Robert Haas Cc: Lukas Fittl , Jacob Champion , Dian Fay , Matheus Alcantara , Jakub Wartak , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Just noticed this in the committed patch, it doesn't seem intentional: (the last line wasn't part of the patch, probably an accidental leftover) src/backend/optimizer/ptah/costsize.c:1462 if (path->parallel_workers == 0) enable_mask |= PGS_CONSIDER_NONPARTIAL; path->disabled_nodes = (baserel->pgs_mask & enable_mask) != enable_mask ? 1 : 0; path->disabled_nodes = 0;