Skip site navigation (1) Skip section navigation (2)

[GENERAL]COPY still running

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 (view raw or flat)
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
______________________________



Responses

pgsql-general by date

Next:From: J. RoeleveldDate: 2000-01-26 09:51:00
Subject: Re: [GENERAL]COPY still running
Previous:From: DSDeurne Automatisering, Wim AartsDate: 2000-01-26 08:36:12
Subject: Re: [GENERAL] Re: server hardware recommendations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group