--howdy:
--okay, then i'm doing something silly. :(
--what i did the first time was to copy
--data from a text file. basically, i did this:
\copy t_table from 'file.txt' using delimiters '|'
--and that was taking too long. i got the bright
--idea to use a perl script to load data with
--'insert'. that, too, is taking too long.
--so, i remembered the Ora2Pg tool.
--how did you use copy to move data?
-X
-----Original Message-----
From: Stephen Frost [mailto:sfrost@snowman.net]
Sent: Friday, September 19, 2003 4:27 PM
To: Johnson, Shaunn
Cc: PgSQL General ML
Subject: Re: [GENERAL] anyone use Ora2Pg?
* Johnson, Shaunn (SJohnson6@bcbsm.com) wrote:
> --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.
Something sounds pretty off. It didn't take nearly that long for me to
load up a fair bit of data.
Stephen