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

From: François Beausoleil <francois(at)teksol(dot)info>
To: Seref Arikan <serefarikan(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Date: 2014-08-10 11:40:48
Message-ID: 0D184F01-0AD8-469E-A3C2-C29EDF3F9C76@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Le 2014-08-10 à 06:31, Seref Arikan <serefarikan(at)gmail(dot)com> a écrit :
>
> 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?

When have you checked? Because the JOIN might use lots of disk space, then the transaction aborts and when you check, there is free space.

Hope that helps,
François

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2014-08-10 13:48:49 Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Previous Message Seref Arikan 2014-08-10 10:31:26 Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"