| From: | David Rees <drees76(at)gmail(dot)com> |
|---|---|
| To: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can't terminate hung COPY |
| Date: | 2013-03-20 20:43:36 |
| Message-ID: | CAHtT9Rv7nv2-B=qqdkJSOJYdf0UYC6ZU+j9xr81A3=oshhMyYw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 20, 2013 at 1:12 PM, Martín Marqués
<martin(dot)marques(at)gmail(dot)com> wrote:
> What happens if you use COPY ... FROM with the same data?
I will try that, but if you look at pg_stat_activity the full command
is a COPY <table> (<columns), FROM STDIN.
> Are you sure the process hangs (strange thing is that you can't
> terminate the backend)? Could it be that it looks like it hung, but
> it's actually COPYing a huge chunk of data?
The file that psql is reading from is tiny - less than 3kB so that's
definitely not the issue...
-Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2013-03-20 20:55:29 | Re: Fast Shutdown (SIGINT) results in a CHECKPOINT... |
| Previous Message | Sean Chittenden | 2013-03-20 20:28:26 | Fast Shutdown (SIGINT) results in a CHECKPOINT... |