Re: Can someone please explain this error

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Can someone please explain this error
Дата
Msg-id 20040718124551.7b1e1050.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на Can someone please explain this error  (Simon Windsor <simon.windsor@cornfield.org.uk>)
Список pgsql-general
Simon Windsor <simon.windsor@cornfield.org.uk> wrote:
> Hi
>
> I have just recevived this error
>
> could not write to hash-join temporary file: No space left on device
>
> Can someone please explain how I can stop this occuring. Whereis the hash-join
> temporary file? How can I make it big? etc.
>
> The query question runs fine in Oracle, MySQL and Postgres normally, but I
> have seen this error twise recently. I have used df -k to check the
> filesystems and none are full, and a Google search has revealed nothing.

How close to full are they?  Is it possible that during load they occasionally
fill up for a short period of time, and then other activity cleans up some
files and frees space?

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

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

Предыдущее
От: Thomas F.O'Connell
Дата:
Сообщение: Re: Indexes and Tables: Growth and Treatment
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: server closed the connection unexpectedly