Postgres Pro
Downloads
Home   >   mailing lists

Huge delay to finish even having all the records inserted - Mailing list pgsql-general

From Alexander Franca Fernandes
Subject Huge delay to finish even having all the records inserted
Date
Msg-id CAKzOpbk+DNVuSem=8PZh=JbO9cCap3GmOECH6Vh_FunzBLogJA@mail.gmail.com
Whole thread Raw
Responses Re: Huge delay to finish even having all the records inserted  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Transfer db from one port to another
Next
From: Killian Driscoll
Date:
Subject: Re: Transfer db from one port to another