Postgres Pro
Downloads
Home   >   mailing lists

Disk space available, but getting error "could not write to hash-join temporary file: No space left on device" - Mailing list pgsql-general

From Seref Arikan
Subject Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Date
Msg-id CA+4Thdr_79rgyyGeLeMFEf9V-=SpTq_J3vinCa+WHssbNpwnQw@mail.gmail.com
Whole thread Raw
Responses Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"  (François Beausoleil <francois@teksol.info>)
List pgsql-general
Tree view
Greetings,
A function aborts with the error in the subject line despite the available free space on the disk.
I have a bunch of other questions regarding the underlying reason but first things first: why is pg telling me no space is left on device when there is space?

the only config param I can see relevant to this is temp_file_limit which I've set to -1, but it made no difference. How can I make sure that as long as there is disk space available, I don't get this error?

Regards
Seref

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Duplicated IDs
Next
From: François Beausoleil
Date:
Subject: Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"