Re: COPY taking forever, I just want to end it!
От | Beth Gatewood |
---|---|
Тема | Re: COPY taking forever, I just want to end it! |
Дата | |
Msg-id | 003101c23358$503870d0$6a01a8c0@bethvizx обсуждение исходный текст |
Ответ на | Re: COPY taking forever, I just want to end it! (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: