Huge delay to finish even having all the records inserted

Поиск
Список
Период
Сортировка
От Alexander Franca Fernandes
Тема Huge delay to finish even having all the records inserted
Дата
Msg-id CAKzOpbk+DNVuSem=8PZh=JbO9cCap3GmOECH6Vh_FunzBLogJA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Huge delay to finish even having all the records inserted
Список 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

В списке pgsql-general по дате отправления: