In response to roctaiwan <nettreeinc at gmail.com>:

> 
> It took about 30 mins to load 1M records. No error messages I observe. 

It would then make sense that 10M would take around 5 hours.  Have you
waited 5 hours to see if they show up after that?  Have you monitored
DB activity after inserting the 10M records to see if it's actively
working to transfer them?

> Jan Wieck wrote:
> > 
> > On 9/25/2009 6:36 AM, roctaiwan wrote:
> >> Here is my concern. I copying both 10k and 1million of records with
> >> success,
> >> but why can't 10Million records? Is this has something to do with my
> >> memory
> >> size, which loading 10Million of records is too much for my server to
> >> handle?
> > 
> > How long does it take Slony to copy those 1M rows?
> > 
> > Are there any error messages in the slon log?

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/