SetOp

Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义，以下显示原始英文内容。

Core node tag: T_SetOp
Structured EXPLAIN Node Type: SetOp
Inputs: Set-operation input plans
Output: Set-operation result tuples
Executor initializer: ExecInitSetOp
Memory mechanism: unclassified
EXPLAIN strategies: Sorted, Hashed
evidence kind: source and documentation
explain names: SetOp, HashSetOp
explain prefixes: Parallel, Async
node tag: T_SetOp
parallel callbacks: 未知
partial modes: 未知
runtime verified: false
strategies: Sorted, Hashed

版本定义 PG 18

Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.

EXPLAIN labels in this source build

Text-format label	Structured node identity
SetOp	SetOp
HashSetOp	SetOp

比较版本

完整来源事实

memory

{"description":"This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider.","evidence":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeSetOp.c","path":"src/backend/executor/nodeSetOp.c","sha256":"337c8a4ab549bd36155243da4f71384647d63b6475bb548f6fcdfd1a663bd8a7","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]}

source inventory

{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeSetOp.c"}

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f