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: | Raw Message | Whole Thread | 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 |