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
______________________________