Re: anyone use Ora2Pg? - Mailing list pgsql-general

From Ron Johnson
Subject Re: anyone use Ora2Pg?
Date
Msg-id 1064011782.3391.26.camel@haggis
Whole thread Raw
In response to Re: anyone use Ora2Pg?  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
On Fri, 2003-09-19 at 15:32, Johnson, Shaunn wrote:
[snip]
> * 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.

Could the table be chock full of indexes?

Still, 2 days to insert 2800 records is less than 1 record per
*minute*.  That's not "pretty off", that's mondo off.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Fair is where you take your cows to be judged."
Unknown


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: OT: HEADS-UP: viral storm out there
Next
From: Tom Lane
Date:
Subject: Re: State of Beta 2