IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / For faster COPYs
Post #241,086
by admin
Picture of admin
1/11/06 10:44:37 PM
Reply
New For faster COPYs
Turn off all indexes, triggers, and constraints on the table. They will all slow down the import.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #241,096
by static
Picture of static
1/11/06 11:36:35 PM
Reply
New Been trying to figure out how to do that.
Now that I've got a whole table in, I can look at pg_dump's output and see how it does it.

Ah... *that's* how to use COPY... I think I'll be writing my own dump tool to do the data migration.

Wade.
"Insert crowbar. Apply force."
     FullText indices in MySQL. - (static) - (17) - Jan. 10, 2006, 11:07:46 PM EST
         Re: FullText indices in MySQL. - (admin) - (3) - Jan. 10, 2006, 11:09:46 PM EST
             It's a political reason. - (static) - (2) - Jan. 10, 2006, 11:23:40 PM EST
                 Boggle. - (admin) - (1) - Jan. 10, 2006, 11:18:38 PM EST
                     Believe me, I want to try it. - (static) - Jan. 10, 2006, 11:26:30 PM EST
         DB2->Bummer - (tuberculosis) - (12) - Jan. 11, 2006, 07:04:38 PM EST
             And porting from Postgres -> Oracle is likely to be easy - (drewk) - (1) - Jan. 11, 2006, 07:14:09 PM EST
                 I've gone the other way - not too hard - pretty close -NT - (tuberculosis) - Jan. 11, 2006, 07:57:21 PM EST
             PostGreSQL may be on the cards again. - (static) - (9) - Jan. 11, 2006, 10:10:00 PM EST
                 For faster COPYs - (admin) - (1) - Jan. 11, 2006, 10:44:37 PM EST
                     Been trying to figure out how to do that. - (static) - Jan. 11, 2006, 11:36:35 PM EST
                 Copy is slow? - (broomberg) - (6) - Jan. 11, 2006, 10:59:58 PM EST
                     Well, I'm doing a psql < filename.sql - (static) - (5) - Jan. 11, 2006, 11:24:58 PM EST
                         Explain the copy command you are using - (broomberg) - (4) - Jan. 11, 2006, 11:32:05 PM EST
                             I wasn't using COPY at all. - (static) - (3) - Jan. 11, 2006, 11:38:57 PM EST
                                 Huh? - (broomberg) - (2) - Jan. 11, 2006, 11:50:35 PM EST
                                     I didn't *know* about it. :-) - (static) - (1) - Jan. 12, 2006, 12:02:20 AM EST
                                         Oh, OK - (broomberg) - Jan. 12, 2006, 12:22:59 AM EST

Gifts to acquaintances and coworkers should be delivered with as much warmth and sincerity as you can fake.
94 ms