Re: [GENERAL] Huge delay to finish even having all the records inserted

2015-12-23 Thread Alexander Franca Fernandes
Yep, you're right! Thank you for your feedback! []s Alex On Wed, Dec 23, 2015 at 1:14 PM, Adrian Klaver wrote: > 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

Re: [GENERAL] Huge delay to finish even having all the records inserted

2015-12-23 Thread Adrian Klaver
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 a

[GENERAL] Huge delay to finish even having all the records inserted

2015-12-23 Thread Alexander Franca Fernandes
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 w