could not write to hash-join temporary file: No space left on device

Поиск
Список
Период
Сортировка
От Moshe Jacobson
Тема could not write to hash-join temporary file: No space left on device
Дата
Msg-id CAJ4CxLk11VG_uh=fX1auKGAXGoajGFVSJG4F+M+xwtGBQvW-zA@mail.gmail.com
обсуждение исходный текст
Ответы Re: could not write to hash-join temporary file: No space left on device  (Martín Marqués <martin@2ndquadrant.com>)
Re: could not write to hash-join temporary file: No space left on device  (Martín Marqués <martin@2ndquadrant.com>)
Re: could not write to hash-join temporary file: No space left on device  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Дерево обсуждения
My database is total around 100 gigs of data, and I have 50 gigs free on the volume, yet I get this error message. It was a simple join. Is there a way to see more information on why I got this error?

--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3