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

Tom Lane-2 wrote:
>
> Alessandra Bilardi <bilardi(at)cribi(dot)unipd(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>

Sorry, I reply only Tom Lane:

From: Alessandra Bilardi <bilardi(at)cribi(dot)unipd(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [GENERAL] could not [extend relation|write block N of temporary
file|write to hash-join temporary file]
Date: Tue, 7 Aug 2007 11:23:55 +0200

Dear Tom,
I attach you the sql script and file.log and file.err obtain with command:
psql -d sgdlite < sgdlite_mart.sql > sgdlite_mart.log 2> sgdlite_mart.err
first server machine is:AMD Opteron(tm) Processor 244, 1790.535MHz, 1024MB
second server machine is:AMD Opteron(tm) Bi Processor 244, 1804.153MHz,
8192MB

I had "could not write to hash-join temporary file" one time with
second server machine.
Thanks for you help.
Regards,

Alessandra Bilardi

http://www.nabble.com/file/p12884512/sgdlite_mart.sql sgdlite_mart.sql
http://www.nabble.com/file/p12884512/sgdlite_mart1.err sgdlite_mart1.err
http://www.nabble.com/file/p12884512/sgdlite_mart1.log sgdlite_mart1.log
http://www.nabble.com/file/p12884512/sgdlite_mart2.err sgdlite_mart2.err
http://www.nabble.com/file/p12884512/sgdlite_mart2.log sgdlite_mart2.log

--
View this message in context: http://www.nabble.com/could-not--extend-relation%7Cwrite-block-N-of-temporary-file%7Cwrite-to-hash-join-temporary-file--tf4216684.html#a12884512
Sent from the PostgreSQL - general mailing list archive at Nabble.com.