Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: could not write to hash-join temporary file: No space left on device
Date
Msg-id CAMkU=1ziPU2wfQPGc071uN3JkQH3MbavMSUP8WdBBzY7LTZQUg@mail.gmail.com
Whole thread Raw
In response to could not write to hash-join temporary file: No space left on device  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Martín Marqués
Date:
Subject: Re: could not write to hash-join temporary file: No space left on device
Next
From: 高健
Date:
Subject: Re: prepared statement functioning range