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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Beth Gatewood" <beth(at)vizxlabs(dot)com>
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 20:41:20
Message-ID: 13717.1027543280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-24 20:49:09 Re: Searching accented words
Previous Message Roderick A. Anderson 2002-07-24 20:35:05 e-mail ERD or table design