Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: 4.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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: