From: Alessandra Bilardi <bilardi@cribi.unipd.it>
To: pgsql-general@postgresql.org
Subject: Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]
Date: Tue, 25 Sep 2007 10:28:34 -0700 (PDT)
Message-ID: <12884512.post@talk.nabble.com> (raw)
In-Reply-To: <16915.1186241901@sss.pgh.pa.us>
References: <18096.21836.812964.708628@gargle.gargle.HOWL>
<16915.1186241901@sss.pgh.pa.us>
Tom Lane-2 wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
Sorry, I reply only Tom Lane:
From: Alessandra Bilardi <bilardi@cribi.unipd.it>
To: Tom Lane <tgl@sss.pgh.pa.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-j...
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bilardi@cribi.unipd.it, pgsql-general@postgresql.org
Subject: Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]
In-Reply-To: <12884512.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox