# HG changeset patch
# User am@osimis.io
# Date 1531213537 -7200
# Node ID 38e23471d132e7ec1014441206185b4728ad7e71
# Parent  dfc7002add9c514027f3ea4fc4165cb48d8a5106
more visibility on the index creation

diff -r dfc7002add9c -r 38e23471d132 PostgreSQL/NEWS
--- a/PostgreSQL/NEWS	Tue Jul 10 07:15:13 2018 +0200
+++ b/PostgreSQL/NEWS	Tue Jul 10 11:05:37 2018 +0200
@@ -1,6 +1,13 @@
 Pending changes in the mainline
 ===============================
 
+Important remark when upgrading from an older version of the Plugin:
+* The plugin will create a new index to improve search performances.
+  This can take several minutes at Orthanc startup.  Orthanc will not
+  be available during this period.
+  On a 100000 studies DB, we've observed that the creation of this index 
+  took around 10 minutes.
+
 * Migration into the "orthanc-databases" repository
 * Full refactoring to share code with MySQL
 * Fix issue 41 (Additional range IdentifierConstraintType in Orthanc)
diff -r dfc7002add9c -r 38e23471d132 PostgreSQL/Plugins/PostgreSQLIndex.cpp
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Tue Jul 10 07:15:13 2018 +0200
+++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Tue Jul 10 11:05:37 2018 +0200
@@ -129,12 +129,13 @@
          **/
         try
         {
-          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
+          LOG(WARNING) << "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);");
 
           SetGlobalIntegerProperty(*db, t, Orthanc::GlobalProperty_HasTrigramIndex, 1);
+          LOG(WARNING) << "Trigram index has been created";
         }
         catch (Orthanc::OrthancException&)
         {