https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319288#M6289 <P>Yes you're right, in your case if all that changed is the PostgreSQL TEXT SEARCH CONFIGURATION then that would be enough and much more efficient.</P> Tue, 29 Oct 2013 18:17:19 GMT Florent_Guillau 2013-10-29T18:17:19Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319283#M6284 <P>Hi,</P> <P>We realized we forgot to adjust the TEXT SEARCH CONFIGURATION in PostgreSQL for a Nuxeo database, to make the full text searches accent-insensitive.</P> <P>We tested the <CODE>CREATE EXTENSION unaccent;</CODE> etc. commands on a medium-sized Nuxeo, which worked well except the first login after launching Nuxeo took longer than usual.</P> <P>I reckon this is more PostgreSQL-related, but does the database have to rebuild the whole index after making changes to this configuration? This could be a problem if we execute the script on our production database, which is much larger than the first one (we don't want to end up with Nuxeo being frozen for... an undefinite amount of time).</P> <P>Thanks for your advice</P> Mon, 28 Oct 2013 17:36:14 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319283#M6284 Marwane_K_A_ 2013-10-28T17:36:14Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319284#M6285 <P>The question really is about how/when the Postgres FTS configuration change applies. As far as I can tell the text search configuration is set up in the nx_to_tsvector function, which is used to build the fts index on the fulltext table.</P> Mon, 28 Oct 2013 17:46:49 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319284#M6285 schambon_ 2013-10-28T17:46:49Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319285#M6286 <P>Nuxeo does not automatically rebuild fulltext indexes when the fulltext configuration changes. The slowdown you're seeing must be coming from somewhere else.</P> <P>If you changed the fulltext configuration you'll need to reindex everything, the <A href="https://github.com/nuxeo/nuxeo-reindex-fulltext">nuxeo-reindex-fulltext</A> addon can do that for you.</P> Mon, 28 Oct 2013 17:50:07 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319285#M6286 Florent_Guillau 2013-10-28T17:50:07Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319286#M6287 <P>Thanks for your answer.</P> Mon, 28 Oct 2013 17:54:43 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319286#M6287 Marwane_K_A_ 2013-10-28T17:54:43Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319287#M6288 <P>The addon works by changing the dc</P> Mon, 28 Oct 2013 18:28:41 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319287#M6288 schambon_ 2013-10-28T18:28:41Z https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319288#M6289 <P>Yes you're right, in your case if all that changed is the PostgreSQL TEXT SEARCH CONFIGURATION then that would be enough and much more efficient.</P> Tue, 29 Oct 2013 18:17:19 GMT https://connect.hyland.com/t5/nuxeo-forum/tweaking-the-text-search-configuration-with-an-existing-database/m-p/319288#M6289 Florent_Guillau 2013-10-29T18:17:19Z