Postgres Pro
Downloads
Home   >   mailing lists

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

From François Beausoleil
Subject Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Date
Msg-id 0D184F01-0AD8-469E-A3C2-C29EDF3F9C76@teksol.info
Whole thread Raw
In response to Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"  (Seref Arikan <serefarikan@gmail.com>)
Responses Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"  (Seref Arikan <serefarikan@gmail.com>)
List pgsql-general
Tree view 
> Le 2014-08-10 à 06:31, Seref Arikan <serefarikan@gmail.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
spaceis 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.
Howcan 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,
thereis free space. 

Hope that helps,
François

pgsql-general by date:

Previous
From: Seref Arikan
Date:
Subject: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Next
From: Seref Arikan
Date:
Subject: Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"