[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL]COPY still running
From: Arnaud FLORENT <aflorent () iris-tech ! fr>
Date: 2000-01-28 11:03:24
[Download RAW message or body]
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@iris-tech.fr
______________________________
************
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic