| From: | Alexander Franca Fernandes <affedem(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Huge delay to finish even having all the records inserted |
| Date: | 2015-12-23 14:49:54 |
| Message-ID: | CAKzOpbk+DNVuSem=8PZh=JbO9cCap3GmOECH6Vh_FunzBLogJA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I'm inserting 14 millions records from a text file using the Postgre COPY
command.
After waiting five days I've realized that all the records seems to be
already inserted,
but the process is still running!!
I don't know if there's any internal postgresql process that impose that I
have to wait even having the records shown in a SELECT query...
I don't know if it's safe to cancel the process right now.
Here's the activity query result (I've cut the columns into lines):
postgres=# SELECT * from pg_stat_activity ;
datid |
--------+
136776 |
-----------------
datname |
----------+
xyzdb |
-----------------
procpid |
---------+-
303311 |
-----------------
usesysid |
---------+-
16387 |
-----------------
usename |
---------+
xyz |
-----------------
current_query |
----------------------------------+-
<IDLE> |
--------------------------------------
waiting |
--------+
f |
-----------------
xact_start |
-------------------------------+
|
-----------------------------------------------------------
query_start |
-------------------------------+
2015-12-18 12:01:05.553534-06 |
-----------------------------------------------------------
backend_start | client_addr | client_port
-------------------------------+-------------+-------------
2015-12-18 12:01:05.547759-06 | | -1
[]s
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Killian Driscoll | 2015-12-23 14:50:13 | Re: Transfer db from one port to another |
| Previous Message | Adrian Klaver | 2015-12-23 14:47:03 | Re: Transfer db from one port to another |