You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Chen Feng (Jira)" <ji...@apache.org> on 2020/07/15 07:33:00 UTC
[jira] [Commented] (PHOENIX-6012) make USE_OF_QUERY_GUIDE_POSTS
configurable to improve query performance.
[ https://issues.apache.org/jira/browse/PHOENIX-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157962#comment-17157962 ]
Chen Feng commented on PHOENIX-6012:
------------------------------------
In our environment, SYSTEM.STATS for TABLE_X has over 10,000 lines. Executing GuidePostsCache$StatsLoader.load() can cost tens of seconds.
A simple method is disable the access of guide posts in BaseResultIterators.useStats() by adding configuration in Connection.
> make USE_OF_QUERY_GUIDE_POSTS configurable to improve query performance.
> ------------------------------------------------------------------------
>
> Key: PHOENIX-6012
> URL: https://issues.apache.org/jira/browse/PHOENIX-6012
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Chen Feng
> Priority: Minor
>
> Loading guide posts from SYSTEM.STATS can cost lots of time.
> When we have knowledge of the data size covered by query scan, we can disable the use of guide posts to improve query performance.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)