Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • Tryton Tryton
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 764
    • Issues 764
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 90
    • Merge requests 90
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Releases
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • External wiki
    • External wiki
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

Due to a massive storm of spam, registration on this instance now requires explicit administrator approval. Sorry for the added friction, we're also looking into automatic filtering options.

  • TrytonTryton
  • TrytonTryton
  • Issues
  • #12480
Closed
Open
Issue created Aug 16, 2023 by Cédric Krier@ced⚛Owner

Support btree_gin extension

The btree_gin extension is useful to create GIN indexes where some expressions are using Range or Equality.

Of course they are less performent then a BTREE if no Similarity is needed. But if there is a mix of Similarity and (Range or Equality), then having a single index instead of two AND-ed indexes may be better.

Also BTREE index has a size limit: https://www.postgresql.org/message-id/25511356.post@talk.nabble.com but not GIN.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking