Home > mailing lists

Best practice to load a huge table from ORACLE to PG - Mailing list pgsql-performance

From	Adonias Malosso
Subject	Best practice to load a huge table from ORACLE to PG
Date	April 26, 2008 13:25:27
Msg-id	8a5d3c890804260625o7ad0700fp79f951c58c242720@mail.gmail.com Whole thread Raw
Responses	Re: Best practice to load a huge table from ORACLE to PG Re: Best practice to load a huge table from ORACLE to PG Re: Best practice to load a huge table from ORACLE to PG Re: Best practice to load a huge table from ORACLE to PG Re: Best practice to load a huge table from ORACLE to PG
List	pgsql-performance

Tree view

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.

Anyone has a better idea.

Regards
Adonias Malosso

pgsql-performance by date:

From: Robert Treat
Date: 26 April 2008, 13:11:45
Subject: Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

From: Thomas Spreng
Date: 26 April 2008, 14:12:50
Subject: Re: Oddly slow queries

Best practice to load a huge table from ORACLE to PG - Mailing list pgsql-performance

Previous

Next