Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Best practi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 10 Topic 4021 of 4294
Post > Topic >>

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

by tino@[EMAIL PROTECTED] (Tino Wildenhain) Apr 28, 2008 at 09:59 PM

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
 




 10 Posts in Topic:
Best practice to load a huge table from ORACLE to PG
malosso@[EMAIL PROTECTED]  2008-04-26 10:25:22 
Re: Best practice to load a huge table from ORACLE to PG
jd@[EMAIL PROTECTED] (&q  2008-04-26 08:10:24 
Re: Best practice to load a huge table from ORACLE to PG
llonergan@[EMAIL PROTECTE  2008-04-26 09:13:34 
Re: Best practice to load a huge table from ORACLE to PG
jonah.harris@[EMAIL PROTE  2008-04-26 21:14:53 
Re: Best practice to load a huge table from ORACLE to PG
gsmith@[EMAIL PROTECTED]   2008-04-27 09:01:46 
Re: Best practice to load a huge table from ORACLE to PG
dfontaine@[EMAIL PROTECTE  2008-04-28 09:49:37 
Re: Best practice to load a huge table from ORACLE to PG
tino@[EMAIL PROTECTED] (  2008-04-28 21:59:02 
Re: Best practice to load a huge table from ORACLE to PG
malosso@[EMAIL PROTECTED]  2008-04-28 18:37:46 
Re: Best practice to load a huge table from ORACLE to PG
jonah.harris@[EMAIL PROTE  2008-04-28 23:31:11 
Re: Best practice to load a huge table from ORACLE to PG
Dorren <database.repli  2008-04-29 00:09:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Sep 6 15:43:02 CDT 2008.