On 24/04/2017 18:42, Dr. David Alan Gilbert wrote: > I suppose there's a few questions; > a) Do we actually need the BQL - and if so why > b) What actually takes 13s? It's probably worth figuring > out where it goes, the whole bitmap is only 1GB isn't it > even on a 4TB machine, and even the simplest way to fill > that takes way less than 13s.
It's more likely that it is the migration_bitmap_sync immediately after that. I think it is possible to move migration_bitmap_sync outside BQL. It should be simpler to evaluate that after Juan's cleanups go in. Paolo