| From: | Arnaud FLORENT <aflorent(at)iris-tech(dot)fr> |
|---|---|
| To: | PostgreSQL general ML <pgsql-general(at)hub(dot)org> |
| Subject: | [GENERAL]COPY still running |
| Date: | 2000-01-26 09:23:46 |
| Message-ID: | 388EBD21.C57A9C3A@iris-tech.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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????
PostgreSQL 6.5.2 running on Pentium II debian server use 98% CPU...
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent(at)iris-tech(dot)fr
______________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. Roeleveld | 2000-01-26 09:51:00 | Re: [GENERAL]COPY still running |
| Previous Message | DSDeurne Automatisering, Wim Aarts | 2000-01-26 08:36:12 | Re: [GENERAL] Re: server hardware recommendations |