Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
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?
Regards
Seref
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 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 <francois@teksol.info>
wrote:
Show quoted text
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 theavailable 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