On Thu, Jun 2, 2011 at 10:01 AM, akp geek <akpg...@gmail.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
