On Thu, Mar 18, 2021, at 8:34 PM, Tomas Vondra wrote:
Well, that's better, bit it still does not do the trick on the 32-bit
machine - in that case a 1000 rows with int4 still fit into work_mem, so
the temp file is not created. Per my experiments about 1040 rows are
needed - soooo close ;-) So let's make it 2000.
My 32-bit laptop needs some repairs so I blindly chose 1k rows.
We might as well check that the temp file actually exists, before
killing the backend. Just to be sure.
Do you mean with remove_temp_files_after_crash = on? New version attached.