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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
