Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38929

DISABLE/ENABLE KEYS support for vector indexes to allow batch HNSW construction

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Vector search
    • None

    Description

      DISABLE KEYS / ENABLE KEYS only works for MyISAM/Aria. there is no equivalent for vector indexes on InnoDB, so there is no way to defer HNSW graph construction during bulk inserts

      it would be nice to have something like this

      ALTER TABLE t DISABLE VECTOR KEYS;
      		 
      // bulk insert\LOAD FILE
      		 
      ALTER TABLE t ENABLE VECTOR KEYS; -- batch builds the HNSW graph

      Attachments

        Issue Links

          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-37009 bulk insert into vector index

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33411 OPTIMIZE TABLE for graph indexes

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              Ahmad_sh Ahmad Shaban
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.