>From: "John" <jgleipold@gmail.com>

>roger@star2000.com.tw wrote:
> > Dear all:
> > I intend to copy large data from ids7.3 to ids10 .
> > The data size about 40 GB includes several hundred tables.
> > I try my best to copy it fast as I can such that
> > - use INSERT .. SELECT command to copy data
> > - create index after copy data
> > - separate into several process running concurrently.
> > - set database unlogged.
> > Is any other way that I can make it faster ?
> > Or any parameters I can modify to make it ?
>
>HPL? (High performance loader)
>

He has the data with a table.

So he can do a select from the local database and insert in to the remote
database, assuming that he can establish a connection to that machine...


This would be faster that the HPL since he's skipping the unload process.

He could do each table in parallel as well.

That would be the *fastest* way.

Well, actually there is a "faster" way, but it would require a tad more
work, however it isn't worth the effort.


-G

__________________________________________________ _______________
Dave vs. Carl: The Insignificant Championship Series. *Who will win?
http://clk.atdmt.com/MSN/go/msnnkwsp...001MSN38C07001