Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jun 14, 2013 at 2:25 PM, Moshe Jacobson <moshe@xxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux