| From: | Martín Marqués <martin(at)2ndquadrant(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-16 23:21:12 |
| Message-ID: | 51BE4868.9010406@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 it more suitable for
PostgreSQL to use temp files if numerous sorting jobs need quite a good
amount o memory.
You might as well try different values of work_mem to see what happens
(watch out for large values of work_mem), or rethink your query all
together.
Cheers,
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-06-17 01:16:23 | Re: could not write to hash-join temporary file: No space left on device |
| Previous Message | Martín Marqués | 2013-06-16 23:11:30 | Re: could not write to hash-join temporary file: No space left on device |