COPY taking forever, I just want to end it!
От | Beth Gatewood |
---|---|
Тема | COPY taking forever, I just want to end it! |
Дата | |
Msg-id | 002901c2333a$545547b0$6a01a8c0@bethvizx обсуждение исходный текст |
Список | 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@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
В списке pgsql-general по дате отправления: