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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: could not write to hash-join temporary file: No space left on device
Дата
Msg-id CAMkU=1ziPU2wfQPGc071uN3JkQH3MbavMSUP8WdBBzY7LTZQUg@mail.gmail.com
обсуждение исходный текст
Ответ на could not write to hash-join temporary file: No space left on device  (Moshe Jacobson <moshe@neadwerx.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Jun 14, 2013 at 2:25 PM, Moshe Jacobson <moshe@neadwerx.com> wrote:
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?

How big are the particular tables that participate in the query?  How many of the columns participate in the query?

It would be useful to see the same information for this as what is recommended here:


Cheers,

Jeff

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: could not write to hash-join temporary file: No space left on device
Следующее
От: 高健
Дата:
Сообщение: Re: prepared statement functioning range