Re: [GENERAL]COPY still running

From: Arnaud FLORENT <aflorent(at)iris-tech(dot)fr>
To: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
Cc: PostgreSQL general ML <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL]COPY still running
Date: 2000-01-28 11:03:24
Message-ID: 3891777C.431B647E@iris-tech.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dirk Lutzebaeck a écrit :

> 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...
>

sure, but i think unique constraints will be lost without index on my
table......

--
______________________________
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
______________________________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jackson, Kevin J. 2000-01-28 16:08:27 error message
Previous Message Yury Don 2000-01-28 10:44:30 Re: [GENERAL] Can you get a whole row with a max on one column