Re: rule of thumb or words of wisdom for btree cleaners?

Alexey Sonkin wrote: > Just put > > BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000 > > in Your $ONCONFIG - and Your desperation will go away My desperation might turn into sadness, no more that that. In my opinion the new btree scanner has at least two major design flaws (I'm not saying that the old concept had none): 1) It has no idea which pages to clean and wastes a lot of i/o bandwidth to find dirty pages by scanning whole indexes or at least whole physical ranges of pages. 2) In some cases instant btree cleaning is a precondition for good insert performance. The new concept cannot deliver that. I would appreciate a discussion about this on this list. Michael