Postgres Pro
Downloads
Home   >   mailing lists

Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file] - Mailing list pgsql-general

From Tom Lane
Subject Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]
Date
Msg-id 16915.1186241901@sss.pgh.pa.us
Whole thread Raw
In response to could not [extend relation|write block N of temporary file|write to hash-join temporary file]  (Alessandra Bilardi <bilardi@cribi.unipd.it>)
Responses Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]  (Alessandra Bilardi <bilardi@cribi.unipd.it>)
List pgsql-general
Tree view 
Alessandra Bilardi <bilardi@cribi.unipd.it> writes:
> ERROR:  could not write to hash-join temporary file: No space left on device

Check your queries.  I suspect you've written an incorrectly constrained
join that is producing many more rows than you expect.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Safe usage of tsearch2: to_tsquery('')
Next
From: Tom Lane
Date:
Subject: Re: List tables in reverse dependancy order