Tue Nov 18 16:36:52 PST 2008
- Previous message: [Slony1-general] Do finishTableAfterCopy and ANALYZE need to be serialized with data copy?
- Next message: [Slony1-general] Do finishTableAfterCopy and ANALYZE need to be serialized with data copy?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Nov 18, 2008, at 4:21 PM, Christopher Browne wrote: > > I *love* seeing heuristics where random selection is the "winning > strategy," but I don't believe that this is the case here. We can be > reasonably certain that the large tables are the ones that will take > longer to REINDEX, and that they are the ones that should be "queued > up" first. I was referring to making sure that each parallel process has about the same amount of work to do, and finishes at about the same time. Ordering by size won't do it unless you assign each worker process in round robin against the ordered set. Perhaps thats your plan. thx Kenny Gorman www.hi5.com
- Previous message: [Slony1-general] Do finishTableAfterCopy and ANALYZE need to be serialized with data copy?
- 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