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.94.2) (envelope-from ) id 1vGBxb-009eCY-NL for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Nov 2025 08:00:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vGBxZ-00BudP-3M for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Nov 2025 08:00:08 +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.94.2) (envelope-from ) id 1vGBxY-00BudG-Pp for pgsql-hackers@lists.postgresql.org; Tue, 04 Nov 2025 08:00:07 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vGBxV-005MoG-34 for pgsql-hackers@lists.postgresql.org; Tue, 04 Nov 2025 08:00:06 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-378cfd75fb0so59844241fa.1 for ; Tue, 04 Nov 2025 00:00:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762243202; x=1762848002; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=LZSEiXy6WvCv/2trZ/VieIQ8qZ7Fyo5E8R0bN7R43+4=; b=L7XsSYFeAp+wNOVpIXUuKpJoKeFfhxocCDB8IjcZa44iz7s7Tl+IvNfMujY0Dr5Ei8 dV+/OirKMMqEVxdTQwOwokTOsHaW3QRpcTeJNWBOZutsP4W5Om8nPPtUdIvhJzJ/gG6j Xre70kMsAAJKmLKE7O2Ex1N3tnkR9s3IiqbUu2X3sdKqBRYJ2qzrrVEoTlzinTGG6NTR Jru6VVPgbX60abuzW/fsvU4XzfbyC2kKq22MkAalVh5IaMI4F6mnPWKz2/u/33ZMhrP9 iZXmG/B7DEEuijw3F9QBT2MVA+ptpN1BNmJP2CWyOE5FsTA6a/7Vl9+k0CBlmJQ+35O7 0SDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762243202; x=1762848002; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=LZSEiXy6WvCv/2trZ/VieIQ8qZ7Fyo5E8R0bN7R43+4=; b=BJzQllnns4XxVbdzvVXrwutUYKyX88FQbgMTSk1t/LeXzpsRx9PszWIqaXvnDixxoH zgUZd1kvPcOJe1H8HIV/po/S3F+9N2AVi8Ooqme/tP5Vgs2Jp3tyHZJkrPt5XFdYSv4z x6tsAoEXlBwJlhNkTZr+1g4Vng92Nip67sIqy65oNUcisWDHD/WjPSqH3zGJgIcOgQvI W8YnuRTgMHIE5PlbtaTGeJalvZZRb1vfa+w1WKySJYUPvIE6fsIFZpyppI1gzxA79PSO NNpBul5LCQNhaHYXdK2DkWv24IwfAkCFdrmryCktbxO3DF4gR5E4ggelzybucPc19jvc OB2Q== X-Gm-Message-State: AOJu0YwNCbzaXfKXHTXmnDfnPLTjdtR1kFMndvp45k1+7qd6nYuOspEy Q1m//CBE+pA88eAQKsS6FgdRgE3hlVONEd/5RYieWGkTpsLV+nGKGrj/ZsmWaQ== X-Gm-Gg: ASbGncunxnlQcmQNSMJIPfiyCR4FP3yrwo3RDFMCanSOo7RakD0UPNGjbT+2l8rKi2E sFt0x8xFYmKas5NKlpi5cOLOn3fP6fEnPxJlXZ4mMQYlVMzbMyorTuaqKQVC0tFfrwZRFPyyArw 6vSrpAsROHaplNmB1UTV4s1i3jAIFrwVhCiWLILDveYw9r5AbI6qKM4wJb5BNAixBUm9qOR0pV0 +xbIHpVfYToI4qzhNMdLwfGNKoGHnZqBtMg94b3HByOaYGznIbJjEsYnMPXIntJ7bAQccOWcKiS XTmwA9Q5J2ckhLZKZi7Cv3NRTU4XlMCD+OOqWfkfkfs5sCnV6yBNnBQkPYKLQbfwaJ34KDxN4U8 sWqs5nnlrz5WtYNYN5t7zfKhEkhrDEIWdNV6+XlJCwPxgC3ZHminbCxJb3MQLTFOSmhtJoSPs1U Uy138= X-Google-Smtp-Source: AGHT+IE78nABStBh66r9cOVDgsLUvuliu1GDmXh1RMIHDoa3lze+iBF2zH1s8u6Z1iv5m42zEYxzlg== X-Received: by 2002:a05:651c:1542:b0:37a:3963:cee1 with SMTP id 38308e7fff4ca-37a3963d6afmr14813631fa.29.1762243202040; Tue, 04 Nov 2025 00:00:02 -0800 (PST) Received: from [192.168.0.50] ([89.149.120.198]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-37a415cb66asm5560241fa.25.2025.11.04.00.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 04 Nov 2025 00:00:01 -0800 (PST) Message-ID: Date: Tue, 4 Nov 2025 10:00:00 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs To: David Rowley , Tom Lane Cc: PostgreSQL Developers References: <976130.1759375308@sss.pgh.pa.us> <1064547.1759418336@sss.pgh.pa.us> <1196118.1759438964@sss.pgh.pa.us> Content-Language: en-US From: Alexander Lakhin In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello David, 04.10.2025 06:55, David Rowley wrote: > On Fri, 3 Oct 2025 at 10:02, Tom Lane wrote: >> David Rowley writes: >>> An alternative way would be to propagate those during build_setop_child_paths() >> That answer works for me. I was expecting you to just document the >> need for the extra check in is_dummy_rel ;-) ... but this way is >> perhaps better. > So, I pushed the UNION portion earlier, but on hacking more on the > EXCEPT/INTERSECT patch, I noticed that I don't have the target lists > correct when marking the top-level set op as dummy. ... Please look at a new anomaly, introduced with 03d40e4b5: CREATE TABLE t(i integer); CREATE TABLE pt(i integer) PARTITION BY LIST(i); SET enable_seqscan = 'off'; SELECT * FROM t UNION SELECT * FROM t UNION ALL SELECT * FROM pt; produces: ERROR:  XX000: unrecognized node type: 0 LOCATION:  create_plan_recurse, createplan.c:538 Best regards. Alexander