Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 20:aacb651833f5
merge
| author | am@osimis.io |
|---|---|
| date | Tue, 10 Jul 2018 11:08:19 +0200 |
| parents | 38e23471d132 9e419261f1c9 |
| children | 4f66bc893fc3 |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp Tue Jul 10 11:05:37 2018 +0200 +++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp Tue Jul 10 11:08:19 2018 +0200 @@ -129,7 +129,10 @@ **/ try { - 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 + // 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"; + db->Execute( "CREATE EXTENSION pg_trgm; " "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers USING gin(value gin_trgm_ops);"); @@ -139,8 +142,10 @@ } catch (Orthanc::OrthancException&) { - LOG(WARNING) << "Performance warning: Your PostgreSQL server does not support trigram matching"; - LOG(WARNING) << "-> Consider installing the \"pg_trgm\" extension on the PostgreSQL server, e.g. on Debian: sudo apt install postgresql-contrib"; + LOG(WARNING) << "Performance warning: Your PostgreSQL server does " + << "not support trigram matching"; + LOG(WARNING) << "-> Consider installing the \"pg_trgm\" extension on the " + << "PostgreSQL server, e.g. on Debian: sudo apt install postgresql-contrib"; } }