Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: 3.11.x
    • Component/s: CQL
    • Labels:
      None

      Description

      Indexing extremely common values is not useful (e.g. where 90% of rows have a null value) because it's actually more efficient to just to a seq scan, so indexing is just wasted effort.

      Rather than requiring users to take that hit if they want anything indexed at all, we should allow specifying a WHERE clause to CREATE INDEX specifying which rows to include in the index. Could include UDF but useful even without it.

      http://www.postgresql.org/docs/9.3/static/indexes-partial.html

        Issue Links

          Activity

          Hide
          iamaleksey Aleksey Yeschenko added a comment -

          Jonathan Ellis Should this be shifted to 3.1?

          Show
          iamaleksey Aleksey Yeschenko added a comment - Jonathan Ellis Should this be shifted to 3.1?
          Hide
          jbellis Jonathan Ellis added a comment -

          Moved.

          Show
          jbellis Jonathan Ellis added a comment - Moved.

            People

            • Assignee:
              Unassigned
              Reporter:
              jbellis Jonathan Ellis
            • Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

              • Created:
                Updated:

                Development