Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6115

Avoid scanning prior row state for uncovered local indexes on immutable tables.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 5.1.0, 4.16.0
    • None
    • None

    Description

      Looking at the code I realized that we retrieve the prior row state even when is not necessary.

      Specifically it is not necessary when (a) the table is immutable and (b) the indexes does not include any covered columns.

      The unnecessary work is in part a consequence of the changes for global consistent indexing.

      Attachments

        1. 6115-master-v2.txt
          4 kB
          Lars Hofhansl
        2. 6115-master.txt
          2 kB
          Lars Hofhansl
        3. 6115-4.x-v2.txt
          3 kB
          Lars Hofhansl

        Activity

          People

            larsh Lars Hofhansl
            larsh Lars Hofhansl
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: