Mercurial > hg > orthanc-databases

changeset 15:dfc7002add9c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
log: warning about index creation duration
author am@osimis.io
date Tue, 10 Jul 2018 07:15:13 +0200
parents 9774802fd05f
children 9e419261f1c9 38e23471d132
files PostgreSQL/Plugins/PostgreSQLIndex.cpp
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Mon Jul 09 20:28:27 2018 +0200
+++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Tue Jul 10 07:15:13 2018 +0200
@@ -129,7 +129,7 @@
          **/
         try
         {
-          LOG(INFO) << "Trying to enable trigram matching on the PostgreSQL database to speed up wildcard searches";
+          LOG(INFO) << "Trying to enable trigram matching on the PostgreSQL database to speed up wildcard searches.  This may take several minutes";  // we've observed 9 minutes on DB with 100000 studies
           db->Execute(
             "CREATE EXTENSION pg_trgm; "
             "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers USING gin(value gin_trgm_ops);");