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@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