François, How vry stupid of me, and how kind of you to point at the obvious thing I was missing.
Best regards Seref On Sun, Aug 10, 2014 at 12:40 PM, François Beausoleil <franc...@teksol.info> wrote: > > > Le 2014-08-10 à 06:31, Seref Arikan <serefari...@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 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
