Tue Nov 18 14:04:55 PST 2008
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] Do finishTableAfterCopy and ANALYZE need to be serialized with data copy?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] Do finishTableAfterCopy and ANALYZE need to be serialized with data copy?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list