shihao zhong <[email protected]> writes: > 4. The hash join change (1811f1af98f) can write outer rows with NULL > keys to a temp file, even with one batch. A LEFT JOIN with 297000 NULL > keys wrote 33 MB of temp files, 18.6 wrote none. With temp_file_limit at > 1MB it fails.
I'm a bit skeptical about this one. The older code would have
put those rows into the primary hash table rather than a dedicated
tuplestore, but either way you risk having to dump them to disk.
regards, tom lane
