François,
How vry stupid of me, and how kind of you to point at the obvious thing I was missing.On Sun, Aug 10, 2014 at 12:40 PM, François Beausoleil <francois@xxxxxxxxxxx> wrote:
> Le 2014-08-10 à 06:31, Seref Arikan <serefarikan@xxxxxxxxx> a écrit :
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.>
> 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?
Hope that helps,
François
