Re: COPY taking forever, I just want to end it!

> -----Original Message-----
Ian,
Thank you so much for rapidly responding!

The file seems to have the correct fields (it is a dump from MySQL
database). Where does this NOTICE log to, btw? I didn't start the
postmaster with logging....

What about just killing the processes? How can I end this?

-Beth

> From: Ian Harding [mailto:ianh(at)tpchd(dot)org]
> Sent: Wednesday, July 24, 2002 10:54 AM
> To: beth(at)vizxlabs(dot)com
> Subject: Re: [GENERAL] COPY taking forever, I just want to end it!
>
>
> I have found that copy takes forever when there are extra
> fields in the data. Copy logs a NOTICE for each record,
> something about "Extra junk ignored". That may take up some
> of the time, but the delay seems way longer than just logging.
>
> Are there such lines in your log?
>
> Ian A. Harding
> Programmer/Analyst II
> Tacoma-Pierce County Health Department
> (253) 798-3549
> mailto: iharding(at)tpchd(dot)org
>
> We have only two things to worry about: That things will never get
> back to normal, and that they already have.
>
>
> >>> "Beth Gatewood" <beth(at)vizxlabs(dot)com> 07/24/02 10:48AM >>>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>