On 12/23/2015 06:49 AM, Alexander Franca Fernandes wrote:
Hi,

I'm inserting 14 millions records from a text file using the Postgre
COPY command.

So how did you execute this?

In other words what is the script you used?


After waiting five days I've realized that all the records seems to be
already inserted,

but the process is still running!!

From what I see it is not running:

http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW

idle: The backend is waiting for a new client command.


Looks to me whatever you used to run the COPY connected and then never disconnected and Postgres is waiting for more instructions on that connection.


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



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to