| From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: anyone use Ora2Pg? |
| Date: | 2003-09-19 20:17:22 |
| Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB05FED8C3@snt452.corp.bcbsm.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--howdy - thanks for the reply ...
--i had tried to use 'copy', but it was taking
--so long ... it took over a weekend to load
--about the same amount of records as using 'insert' (i have
--been running this program for over 2 days and only
--have 2800 records to show out of 1/2 a million records).
--i was looking for something faster. could be my server ...
--looking at the system usage, it doesn't seem very high.
-X
-----Original Message-----
From: Stephen Frost [mailto:sfrost(at)snowman(dot)net]
* Johnson, Shaunn (SJohnson6(at)bcbsm(dot)com) wrote:
> Has anyone used the Ora2Pg tool for exporting
> data to PostgreSQL? I'm trying to move data
> over, and my perl script to insert records
> into the PostgreSQL table is going very slowly.
Use copy? I'm pretty sure that's what I did...
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-09-19 20:20:50 | Re: Outer Join help please |
| Previous Message | Stephen Frost | 2003-09-19 20:10:02 | Re: anyone use Ora2Pg? |