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

Welcome to IWETHEY!

New Explain the copy command you are using
Show me exactly what you are doing.
I would hope you are staying away from CSV and using tab delimited data.


And study this page:
[link|http://www.postgresql.org/docs/8.1/interactive/sql-copy.html|http://www.postgresq...ive/sql-copy.html]

Note this text:


Do not confuse COPY with the psql instruction \\copy. \\copy invokes COPY FROM STDIN or COPY TO STDOUT, and then fetches/stores the data in a file accessible to the psql client. Thus, file accessibility and access rights depend on the client rather than the server when \\copy is used.
New I wasn't using COPY at all.
I was using INSERT. After all, that's the portable format, isn't it? :-) Besides, that's what MySQL uses for dump-n-restore. I'll be building a migration tool, I think.

Wade.
"Insert crowbar. Apply force."
New Huh?
It provides an excellant tool for very quick data migration.
And you whine about the speed of not using it.
Makes no sense.
New I didn't *know* about it. :-)
... until the last few hours. I discovered it literally minutes after the initial post about how slow the import was.

Wade.
"Insert crowbar. Apply force."
New Oh, OK
Learn it.
Use it.
Let me know if you neeed any help in working with it.
The key issue is let the Postgres backend see the files, do not load through the network.
     FullText indices in MySQL. - (static) - (17)
         Re: FullText indices in MySQL. - (admin) - (3)
             It's a political reason. - (static) - (2)
                 Boggle. - (admin) - (1)
                     Believe me, I want to try it. - (static)
         DB2->Bummer - (tuberculosis) - (12)
             And porting from Postgres -> Oracle is likely to be easy - (drewk) - (1)
                 I've gone the other way - not too hard - pretty close -NT - (tuberculosis)
             PostGreSQL may be on the cards again. - (static) - (9)
                 For faster COPYs - (admin) - (1)
                     Been trying to figure out how to do that. - (static)
                 Copy is slow? - (broomberg) - (6)
                     Well, I'm doing a psql < filename.sql - (static) - (5)
                         Explain the copy command you are using - (broomberg) - (4)
                             I wasn't using COPY at all. - (static) - (3)
                                 Huh? - (broomberg) - (2)
                                     I didn't *know* about it. :-) - (static) - (1)
                                         Oh, OK - (broomberg)

Jabber is not a command line!
51 ms