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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Moshe Jacobson <moshe(at)neadwerx(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not write to hash-join temporary file: No space left on device
Date: 2013-06-17 01:16:23
Message-ID: CAMkU=1ziPU2wfQPGc071uN3JkQH3MbavMSUP8WdBBzY7LTZQUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 14, 2013 at 2:25 PM, Moshe Jacobson <moshe(at)neadwerx(dot)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:

http://wiki.postgresql.org/wiki/Slow_Query_Questions

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 高健 2013-06-17 01:53:55 Re: prepared statement functioning range
Previous Message Martín Marqués 2013-06-16 23:21:12 Re: could not write to hash-join temporary file: No space left on device