Help on copy function

From: frederic(dot)germaneau(at)bull(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Help on copy function
Date: 2004-10-06 16:08:28
Message-ID: OF0BA9F54A.8A12B6E8-ONC1256F25.00554B33@frec.bull.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to stress PostgreSQL 8beta3 on AIX5.2 with TPCH 1 Go

I have created and configurated a database on 2 tablespaces : first one for
indexes and second one for tables
First script for database creation:

$ more scrCreateDataBase.sh
psql template1<<!
create tablespace dataTbl location '/postgres_data/TpchDataTableSpace';
create tablespace indexTbl location '/postgres_data/TpchIndexTableSpace';
!
createdb tpch
psql tpch<<!
create schema postgres tablespace dataTbl;
!

An example of table script:
$ more cre_tab_part.sql
CREATE TABLE part(
p_partkey bigint NOT NULL,
p_type varchar(25) ,
p_size integer ,
p_brand char(10) ,
p_name varchar(55) ,
p_container char(10) ,
p_mfgr char(25) ,
p_retailprice decimal ,
p_comment varchar(23)
)
;
ALTER TABLE part ADD CONSTRAINT pk_part PRIMARY KEY(p_partkey) USING INDEX
TABLE
SPACE indexTbl;
\q

I populate my database with a shell script which is launching in parallel
each copy statement:
$ more load.sh
for i in `ls *.loader.psql`
do
psql -f $i tpch &
done

An example of copy statement file:
$ more lineitem.loader.psql
\copy lineitem from lineitem.tbl.psql delimiter '|'

And an error occurs :
psql:lineitem.loader.psql:1: ERROR: could not extend relation
24342131/24342133
/24342324: There is not enough space in the file system.
HINT: Check free disk space.
CONTEXT: COPY lineitem, line 1:
"1996-03-13|1|0.04|21168.23|7706|17|N|155190|O|
0.02|1996-02-12|1996-03-22|TRUCK|1|DELIVER IN PERSON|b..."

but my fileSystem has something like 2Go free when copy fails!

Has anybody an explication? Which error I have done?

Thanks

Frédéric GERMANEAU

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schaber 2004-10-06 16:16:53 Avoiding explicit addDataType calls for PostGIS
Previous Message Tom Lane 2004-10-06 16:00:16 Re: Cache lookup failed for relation, when trying to DROP