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

From: Seref Arikan <serefarikan(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Date: 2014-08-10 10:31:26
Message-ID: CA+4Thdr_79rgyyGeLeMFEf9V-=SpTq_J3vinCa+WHssbNpwnQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Beausoleil 2014-08-10 11:40:48 Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Previous Message Alban Hertroys 2014-08-09 16:46:25 Re: Duplicated IDs