Re: Best practice to load a huge table from ORACLE to PG

Adonias Malosso wrote:
> Hi All,
> 
> I´d like to know what´s the best practice to LOAD a 70 milion rows, 101 
> columns table
> from ORACLE to PGSQL.
> 
> The current approach is to dump the data in CSV and than COPY it to 
> Postgresql.
> 
Uhm. 101 columns you say? Sounds interesting. There are dataloaders
like: http://pgfoundry.org/projects/pgloader/
 which could speed
up loading the data over just copy csv. I wonder how much normalizing
could help.

Tino

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance