James Taylor created PHOENIX-1693:
-------------------------------------
Summary: Stats sometimes cause query to execute more slowly
Key: PHOENIX-1693
URL: https://issues.apache.org/jira/browse/PHOENIX-1693
Project: Phoenix
Issue Type: Bug
Reporter: Mujtaba Chohan
After initial data load with Phoenix 4.3.0 with stats enabled for 500M FHA
table using Pherf, aggregate count queries over 5% or 15% of total rows are
some times 2-5X slow compared to queries without stats. Needs to investigate
the root cause.
Observations:
* After major compaction with new stats are re-generated and queries become
fast compared to tables without stats.
* Trucating stats table after initial data load also makes queries perf.
comparable to previous Phoenix release with stats disabled.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
