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

Поиск
Список
Период
Сортировка
От Seref Arikan
Тема Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"
Дата
Msg-id CA+4Thdr_79rgyyGeLeMFEf9V-=SpTq_J3vinCa+WHssbNpwnQw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"  (François Beausoleil <francois@teksol.info>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Duplicated IDs
Следующее
От: François Beausoleil
Дата:
Сообщение: Re: Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"