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

From Tom Lane
Subject Re: COPY taking forever, I just want to end it!
Date
Msg-id 13717.1027543280@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY taking forever, I just want to end it!  ("Beth Gatewood" <beth@vizxlabs.com>)
Responses Re: COPY taking forever, I just want to end it!  ("Beth Gatewood" <beth@vizxlabs.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: e-mail ERD or table design
Next
From: Tom Lane
Date:
Subject: Re: Searching accented words