Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-14907

Impl a limited fulltext mode for VCS when using Elasticsearch

    XMLWordPrintable

    Details

    • Tags:
    • Upgrade notes:
      Hide

      If you want to disable VCS fulltext search on an existing instance, you need to manually remove the trigger and indexes:

      -- for postgresql
DROP TRIGGER nx_trig_ft_update ON fulltext;
DROP INDEX fulltext_fulltext_idx;
DROP INDEX fulltext_fulltext_title_idx;
      Show
      If you want to disable VCS fulltext search on an existing instance, you need to manually remove the trigger and indexes: -- for postgresql DROP TRIGGER nx_trig_ft_update ON fulltext ; DROP INDEX fulltext_fulltext_idx; DROP INDEX fulltext_fulltext_title_idx;
    • Sprint:
      Sprint RepoTeam 5.9.5-2

      Description

      When all the fulltext queries are handled by elasticsearch, there is no more need to maintain database fulltext index.

      At the moment the fulltext mode can only be enabled or disabled. When using elasticsearch we want to keep the binary fulltext extraction but don't want the database fulltext triggers and indexing overhead.

      Done by adding a new fulltext repository option "searchDisabled", can be set using nuxeo.conf  nuxeo.vcs.fulltext.search.disabled=true
      See http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration for more info.

        Attachments

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-18786 Make DBS MongoDB/Mem obey fulltext configuration

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Task - A task that needs to be done. NXP-15228 Disable full text indexation in CAP

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. NXP-19447 Impl the limited fulltext mode for MySQL when using Elasticsearch

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: