Re: Statistics collection in Phoenix

2016-11-02 Thread Mich Talebzadeh
Thanks Sergey for clarification. Regards Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com *Disclaimer:* Us

Re: Statistics collection in Phoenix

2016-11-02 Thread Sergey Soldatov
Hi Mich, The statistic is stored in SYSTEM.STATS table. And yes, there are guideposts per column family. As for (3) and (4) I think the answer is no. Guideposts are more like a point for specific row key (so if we scan for specific row key we can find quickly whether to start scanning) and let us r

Re: Phoenix Slow Problem

2016-11-02 Thread Sergey Soldatov
Hi Fawaz, Actually explain plan says that there will be 6 parallel full scans. I believe that's the number of regions you have. If you want to increase the number of parallel scans you may think about setting phoenix.stats.guidepost.width to something smaller than default value and scans will be ex