Re: COPY taking forever, I just want to end it! - Mailing list pgsql-general

From Beth Gatewood
Subject Re: COPY taking forever, I just want to end it!
Date
Msg-id 003101c23358$503870d0$6a01a8c0@bethvizx
Whole thread Raw
In response to Re: COPY taking forever, I just want to end it!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Searching accented words
Next
From: "Dean Grubb"
Date:
Subject: True/False Values