Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-16044

Query SSTable Indexes lazily in token sorted runs for LCS, TWCS or RangeAwaredCompaction

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Normal
    • Resolution: Unresolved
    • 5.x
    • Feature/SASI
    • None
    • Performance
    • Normal
    • All
    • None

    Description

      Currently SASI searches all SSTable indexes that may include the query partition key and indexed term, but this will cause large IO overhead with range index query (ie. age > 18) when sstable count is huge.

      Proposed improvement: query sstable indexes in token-sorted-runs lazily. When the data in the first few token ranges is sufficient for limit, SASI can reduce the overhead of searching sstable indexes for the remaining ranges.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jasonstack Zhao Yang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: