Re: COPY taking forever, I just want to end it!

From: "Beth Gatewood" <beth(at)vizxlabs(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'Ian Harding'" <ianh(at)tpchd(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY taking forever, I just want to end it!
Date: 2002-07-24 21:23:10
Message-ID: 003101c23358$503870d0$6a01a8c0@bethvizx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Wednesday, July 24, 2002 1:41 PM
> To: Beth Gatewood
> Cc: 'Ian Harding'; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] COPY taking forever, I just want to end it!
>
>
> "Beth Gatewood" <beth(at)vizxlabs(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dean Grubb 2002-07-25 00:40:41 True/False Values
Previous Message Tom Lane 2002-07-24 20:49:09 Re: Searching accented words