MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <18096.21836.812964.708628@gargle.gargle.HOWL>
Date: Wed, 1 Aug 2007 11:41:32 +0200
From: Alessandra Bilardi <bilardi@cribi.unipd.it>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: could not [extend relation|write block N of temporary file|write to
	hash-join temporary file]

Hi everyone,
I use PostgreSQL 8.1.9 and Debian 4.0 "etch" Linux kernel 2.6.18 
(debian precompiled).

I install my db and insert one test database without problems.
I create schema of this db as sql script. Sql script is a list about
create relation table test_table.TEMP__N and set relation and drop 
relation table where N about from 0 to 300.

When I insert sql script with shell command:
psql -d test < script.sql > script.log 2> script.err
in file error I see 3 error sort:
ERROR:  could not extend relation 1663/63659/85595: No space left on device
ERROR:  could not write block 21 of temporary file: No space left on device
ERROR:  could not write to hash-join temporary file: No space left on device

I test all in two server machines:
1) AMD Opteron(tm) Processor 244, 1790.535MHz, 1024MB
2) AMD Opteron(tm) Bi Processor 244, 1804.153MHz, 8192MB

First errors begining when sql script inserts:
1) relation about TEMP__100
2) relation about TEMP__227

In any case there is space in device after sql script:
1)
Filesystem             Dim  Used  Free Used Mount
/dev/md0              953M  254M  699M  27% /
tmpfs                 503M     0  503M   0% /lib/init/rw
udev                   10M   88K   10M   1% /dev
/dev/md1              5,6G  2,4G  3,2G  43% /var
/dev/md2              5,6G  3,5G  2,2G  62% /usr
/dev/md3              953M  340K  952M   1% /tmp
2)
Filesystem             Dim  Used  Free Used Mount
/dev/md0              953M  217M  737M  23% /
tmpfs                 3,9G     0  3,9G   0% /lib/init/rw
udev                   10M   88K   10M   1% /dev
/dev/md4              133G   67G   66G  51% /era
/dev/md3              953M  384K  952M   1% /tmp
/dev/md2              5,6G  3,0G  2,7G  54% /usr
/dev/md1              5,6G  915M  4,7G  17% /var

Can someone help me? 
Thanks very much for the help in advance.

Alessandra Bilardi
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 CRIBI, University of Padova, Italy  |  http://www.linkedin.com/in/bilardi
 Via Ugo Bassi, 58/B - 35121 Padova  |  http://www.alessandrabilardi.com/
 Tel 0498276165  --  Fax 0498276159  |  bilardi@cribi.unipd.it
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=