> > 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.
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"