[jira] [Created] (PHOENIX-7725) Move IndexVerify Thread Pool to RegionServer level

["Viraj Jasani (Jira)" <ji...@apache.org>]

Viraj Jasani created PHOENIX-7725:
-------------------------------------

             Summary: Move IndexVerify Thread Pool to RegionServer level
                 Key: PHOENIX-7725
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7725
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Viraj Jasani


As of today, the IndexVerify thread pool is created at the scanner level, specifically when a GlobalIndexRegionScanner is opened for index verification operations. This means, a new thread pool is created every time a scanner opens, even if verification is not needed. Similarly, the thread pool is shut down when the scanner closes. This is expensive overhead, specifically for the frequent single row point lookup reads.

Index write operations use a shared thread pool at the regionserver level (pre and post writer thread pools).

The proposal of this Jira is to move the IndexVerify thread pool from scanner level to regionserver level. This will eliminate expensive thread pool creation overhead for each scanner initialization. It will keep the thread pool management in close alignment with the covered index write path and uncovered index read path (uncovered index thread pool is now available at regionserver level).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)