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
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 |