Unanswered: Need help for migarating huge data into postgresql
I have 40 millions of data to migrate into a single table of Postgresql database. I need to improve the performance of postgres database to import such a huge data. I need you people to tune the database and tables to import these data with high performance.
Also, I need any effective migration tools which supports postgres.
It importing 10,000 records per minute. I am just thinking on any performance tuning, may improve the insertion speed.
FYI: All the data in text file. I am using java code to read the file and inserting it into the database directly. I am using postgres8.2 database version.
I didn't know how to look at the partioning of Target table. Can you please help me on this too?