On Thu, Jun 2, 2011 at 10:01 AM, akp geek <akpgeek(at)gmail(dot)com> wrote:
> Thanks so much . I was using bullzip What I felt with Bullzip was it is good
> for less amount of data. I have 2 tables each of which has 2.5 million
> records. For me it is taking for ever, The job that I set up has been
> running since 12 hours.
Export to CSV or tab delimited file, then suck it in with a COPY
statement in postgres. Just make sure that there is no "invalid" data
like fake dates. 2.5 million rows should take a couple of minutes
tops to insert into a modern hardware server.