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

2013-06-16 Thread Jeff Janes
On Fri, Jun 14, 2013 at 2:25 PM, Moshe Jacobson 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 table

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

2013-06-16 Thread Martín Marqués
El 14/06/13 18:25, Moshe Jacobson escribió: 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? Forgot to say. A low value of work_mem will make i

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

2013-06-16 Thread Martín Marqués
El 14/06/13 18:25, Moshe Jacobson escribió: 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? Hash-joins can use a lot of space on temp files. T

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

2013-06-14 Thread Moshe Jacobson
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, Suit