# HG changeset patch # User am@osimis.io # Date 1531199713 -7200 # Node ID dfc7002add9c514027f3ea4fc4165cb48d8a5106 # Parent 9774802fd05fd54af4a93700e74242fd16d557bd log: warning about index creation duration diff -r 9774802fd05f -r dfc7002add9c PostgreSQL/Plugins/PostgreSQLIndex.cpp --- 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);");