could not write to hash-join temporary file: No space left on device

1. SQL> create tablespace temp_tbs location '/some/big/disk';
2. change temp_tablespaces = 'temp_tbs' in postgresql.conf.
3. select pg_reload_conf();
4. enjoy

I got the same issue, but I was working with docker.

Just in case if you are working with docker too, go to:

Docker Preferences > Disk Panel > Disk image size and increase it.

It solved my problem.