Postgres Pro
Downloads
Home   >   mailing lists

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

From Moshe Jacobson
Subject could not write to hash-join temporary file: No space left on device
Date
Msg-id CAJ4CxLk11VG_uh=fX1auKGAXGoajGFVSJG4F+M+xwtGBQvW-zA@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Next
From: Michael Paquier
Date:
Subject: Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3