Huge delay to finish even having all the records inserted

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

Responses

Browse pgsql-general by date

  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