Evaluate index definitions in light of index-only scans

ExportXMLWordPrintable

    • Type: Task
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: None
    • Component/s: Schema Change
    • None

      Postgres 9.2+ supports index-only scans. This means that it can be useful to have indexes with additional columns that aren't used as predicates, if that allows using an index-only scan for some join. We should go through the potentially affected queries and check whether extending an index might improve performance.

            Assignee:
            Ulrich Klauer
            Reporter:
            Ulrich Klauer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:

                Version Package