Hmm, if you do an enable_hashagg=false and then run the query (without
explain) does it work then?
pointspp=# set enable_hashagg = false;
SET
pointspp=# select trid, count(*) from pptran group by trid having
count(*) > 1;
ERROR: could not write block 661582 of temporary file: No space left on
device
HINT: Perhaps out of disk space?
Still does not work, but it no longer consumes that same amount of memory
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
