Arnaud FLORENT writes:
> Hello i start yesterday afternoon a COPY command into a table.
> the file is 15 Mb
> i've set triggers before and after insert on the table
> the before trigger just perform data check.
> the after trigger update a 10 000 rows linked table.
> the COPY command runs all the night ad has not yet finished...........
> what is the problem????
You probably have indexes defined on this table. You should drop all
the indexes before the copy and create them after the copy if the
number of rows in the copy commands exceeds the number of the current
rows in the table.
I have dropped the indexes while copy'ing which seems to be no
problem. Just create them after the copy is finished. Ymmv...
In response to
pgsql-general by date
|Next:||From: Donald Dade||Date: 2000-01-26 12:11:02|
|Subject: Format of PgDatabase::PgDatabase(char *conn)|
|Previous:||From: Marc Tardif||Date: 2000-01-26 11:09:26|
|Subject: Re: [GENERAL] upgrade postgreSQL|