Thanks to all who so kindly replied! Actually the COPY ended after about 20
hours...not so great.
There are no FK...There is a primary key and 3 non-unique indices on the
table. I am going to drop all of those and try it again! The data seems to
be well structured (same number of fields in the table vs the tab delimited
fields coming in...)
Thanks!
Beth
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Wednesday, July 24, 2002 1:41 PM
> To: Beth Gatewood
> Cc: 'Ian Harding'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] COPY taking forever, I just want to end it!
>
>
> "Beth Gatewood" <beth@vizxlabs.com> writes:
> > What about just killing the processes? How can I end this?
>
> SIGINT to the backend should work fine.
>
> I can't think of a reason for COPY to be so slow unless you have
> triggers or foreign keys on the table --- any of those?
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>