Huge delay to finish even having all the records inserted

Поиск

Список

Период

Сортировка

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

[]s

Alex

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

От: Adrian Klaver
Дата: 23 декабря 2015 г., 17:47:48
Сообщение: Re: Transfer db from one port to another

От: Killian Driscoll
Дата: 23 декабря 2015 г., 17:50:38
Сообщение: Re: Transfer db from one port to another