| From: | Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com> |
|---|---|
| To: | Arnaud FLORENT <aflorent(at)iris-tech(dot)fr> |
| Cc: | PostgreSQL general ML <pgsql-general(at)hub(dot)org> |
| Subject: | Re: [GENERAL]COPY still running |
| Date: | 2000-01-26 11:36:48 |
| Message-ID: | 14478.56400.116298.140723@ampato.aeccom.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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...
Dirk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Donald Dade | 2000-01-26 12:11:02 | Format of PgDatabase::PgDatabase(char *conn) |
| Previous Message | Marc Tardif | 2000-01-26 11:09:26 | Re: [GENERAL] upgrade postgreSQL |