Richard Yen dba at richyen.com
Tue Nov 18 14:04:55 PST 2008
Hello,

This might be moot with the coming release of Slony 2.0.0, but I was  
wondering if there are any thoughts about the following question:

Do the finishTableAfterCopy() and ANALYZE of each table need to happen  
in serial with the data copy from stdin?  i.e., can we create a new  
thread that will do these two things while slon proceeds to copy the  
data of the next table?

I raise this question because for large data sets, I think the  
copy_set process time could be improved by 30-40% if we can split  
these two stages.  I have some large tables that take 30 min or so to  
copy, then another 15-20 min to finishTableAfterCopy() and ANALYZE.

Thought I'd throw this out to get some feedback, before I go and  
mangle code...any thoughts?
--Richard


More information about the Slony1-general mailing list