Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Fix Version/s: 4.x
    • Component/s: Legacy/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 Assign to me
              Reporter:
              jbellis Jonathan Ellis

              Dates

              • Created:
                Updated:

                Issue deployment