COPY taking forever, I just want to end it!

From: "Beth Gatewood" <beth(at)vizxlabs(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: COPY taking forever, I just want to end it!
Date: 2002-07-24 17:48:31
Message-ID: 002901c2333a$545547b0$6a01a8c0@bethvizx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to copy 5917328 tuples into a single table (I am running it
through a perl script that makes a system call to psql -c sending in the
command). This now seems to still be running 19.5 hours later which is not
reasonable. I am not sure why this is taking so long....I didn't disable
indices so this may be part of the problem.....
However, my questions are:
1- do I kill off all the process below?
[root(at)india pgsql7.2]# ps -auxwww | grep post
postgres 9316 0.0 0.4 5268 1096 ? S Jul08 0:00
/usr/local/pgsql7.2/bin/postmaster -i -D /usr/local/pgsql7.2/data/
postgres 9317 0.0 0.1 6260 344 ? S Jul08 0:00 postgres:
stats buffer process
postgres 9318 0.0 0.2 5340 540 ? S Jul08 0:00 postgres:
stats collector process
postgres 9721 7.1 1.0 5676 2624 ? D 03:15 82:14 postgres:
beth array [local] COPY
postgres 11202 0.0 1.2 5904 3076 ? S 21:25 0:00 postgres:
beth array [local] idle
root 11279 0.0 0.4 2264 1048 pts/5 S 21:51 0:00 su postgres
postgres 11281 0.0 0.5 2448 1400 pts/5 S 21:51 0:00 bash
root 11406 0.0 0.2 1624 616 pts/5 S 22:25 0:00 grep post

2- Also-why is 11202 idle?

3- Would pg_ctl stop -m fast be a way to end a problem like this?

Thanks-Beth

Browse pgsql-general by date

  From Date Subject
Next Message Massoud 2002-07-24 17:50:11 Data Corruptions (How to delete a corrupted row?)
Previous Message Josh Berkus 2002-07-24 17:43:02 Re: [SQL] Readline ... a lot of problems...