Best practice to load a huge table from ORACLE to PG

Поиск
Список
Период
Сортировка
От Adonias Malosso
Тема Best practice to load a huge table from ORACLE to PG
Дата
Msg-id 8a5d3c890804260625o7ad0700fp79f951c58c242720@mail.gmail.com
обсуждение исходный текст
Ответы 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
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
Следующее
От: Thomas Spreng
Дата:
Сообщение: Re: Oddly slow queries