postgresql 无法写入哈希连接临时文件：设备上没有剩余空间
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/29602409/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
could not write to hash-join temporary file: No space left on device
提问by Yousuf Sultan
I am executing PostgreSQL functions to update a table which has a huge amount of data and the update happens for about 100000 records everyday. During the update I get an error saying:
我正在执行 PostgreSQL 函数来更新一个包含大量数据的表，并且每天更新大约 100000 条记录。在更新期间，我收到一条错误消息：
"could not write to hash-join temporary file: No space left on device"
I have not really been able to get something useful to overcome this error. I got something where it says to SET a temporary table spaces. But I was not able to find how do I create a temporary table space where the data will be stored during the executing of the update procedure.
我还没有真正能够得到一些有用的东西来克服这个错误。我得到了一些东西，它说要设置一个临时表空间。但是我无法找到如何创建一个临时表空间，在执行更新过程期间将存储数据。
采纳答案by Vao Tsun
SQL> create tablespace temp_tbs location '/some/big/disk';- change
temp_tablespaces = 'temp_tbs'in postgresql.conf. select pg_reload_conf();- enjoy
SQL> create tablespace temp_tbs location '/some/big/disk';temp_tablespaces = 'temp_tbs'postgresql.conf 中的更改。select pg_reload_conf();- 请享用
回答by pruthvi nath
I got the same issue, but I was working with docker.
我遇到了同样的问题，但我正在使用 docker。
Just in case if you are working with docker too, go to:
以防万一，如果您也使用 docker，请访问：
Docker Preferences> Disk Panel> Disk image sizeand increase it.
Docker Preferences> Disk Panel>Disk image size并增加它。
It solved my problem.
它解决了我的问题。
