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

From Beth Gatewood
Subject COPY taking forever, I just want to end it!
Date
Msg-id 002901c2333a$545547b0$6a01a8c0@bethvizx
Whole thread Raw
List 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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Using FTI-Search (likely a more general runtime-puzzle)
Next
From: Massoud
Date:
Subject: Data Corruptions (How to delete a corrupted row?)