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