Kenny Gorman kgorman at hi5.com
Tue Nov 18 16:36:52 PST 2008
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


More information about the Slony1-general mailing list