Re: [GENERAL]COPY still running - Mailing list pgsql-general

From J. Roeleveld
Subject Re: [GENERAL]COPY still running
Date
Msg-id 00a101bf67e9$43d47060$8402a8c0@sentec.demon.nl
Whole thread Raw
In response to [GENERAL]COPY still running  (Arnaud FLORENT <aflorent@iris-tech.fr>)
List pgsql-general
> I had a similar thing once, while compiling a program, it took the
computer
> 28 hours to complete. (on a P200)
>
> My best guess is is that it's still running, make a quick check that the
> main
> process is still running. The action you are doing requires not just alot
of
> CPU-power, but also a lot of HD-read and writes.

the postmaster is still running and the database grows (it is not very fast
but
it grows and is now 60Mb large......)

glad to hear, it's not crashed... :)

is thare a way to stop the copy command wihtout crashing the database?

It depends, if you issued the command within 'psql' then yes, by pressing
<ctrl>+C
however, this will cause the entire transaction to be reversed, and will
very
likely take the same amount of time, my advise would still be to let this
command to finish normally...

with kind regards,

Joost Roeleveld


pgsql-general by date:

Previous
From: Arnaud FLORENT
Date:
Subject: Re: [GENERAL]COPY still running
Next
From: Sevo Stille
Date:
Subject: Re: [GENERAL] Re: server hardware recommendations