Help on copy function
От | frederic.germaneau@bull.net |
---|---|
Тема | Help on copy function |
Дата | |
Msg-id | OF0BA9F54A.8A12B6E8-ONC1256F25.00554B33@frec.bull.fr обсуждение исходный текст |
Ответы |
Re: Help on copy function
|
Список | 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
В списке pgsql-general по дате отправления: