Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 20:aacb651833f5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge
author am@osimis.io
date Tue, 10 Jul 2018 11:08:19 +0200
parents 38e23471d132 9e419261f1c9
children 4f66bc893fc3
comparison
equal deleted inserted replaced
19:38e23471d132 20:aacb651833f5
127 * https://www.postgresql.org/docs/current/static/pgtrgm.html 127 * https://www.postgresql.org/docs/current/static/pgtrgm.html
128 * https://bitbucket.org/sjodogne/orthanc/issues/47/index-improvements-for-pg-plugin 128 * https://bitbucket.org/sjodogne/orthanc/issues/47/index-improvements-for-pg-plugin
129 **/ 129 **/
130 try 130 try
131 { 131 {
132 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 132 // We've observed 9 minutes on DB with 100000 studies
133 LOG(WARNING) << "Trying to enable trigram matching on the PostgreSQL database "
134 << "to speed up wildcard searches. This may take several minutes";
135
133 db->Execute( 136 db->Execute(
134 "CREATE EXTENSION pg_trgm; " 137 "CREATE EXTENSION pg_trgm; "
135 "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers USING gin(value gin_trgm_ops);"); 138 "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers USING gin(value gin_trgm_ops);");
136 139
137 SetGlobalIntegerProperty(*db, t, Orthanc::GlobalProperty_HasTrigramIndex, 1); 140 SetGlobalIntegerProperty(*db, t, Orthanc::GlobalProperty_HasTrigramIndex, 1);
138 LOG(WARNING) << "Trigram index has been created"; 141 LOG(WARNING) << "Trigram index has been created";
139 } 142 }
140 catch (Orthanc::OrthancException&) 143 catch (Orthanc::OrthancException&)
141 { 144 {
142 LOG(WARNING) << "Performance warning: Your PostgreSQL server does not support trigram matching"; 145 LOG(WARNING) << "Performance warning: Your PostgreSQL server does "
143 LOG(WARNING) << "-> Consider installing the \"pg_trgm\" extension on the PostgreSQL server, e.g. on Debian: sudo apt install postgresql-contrib"; 146 << "not support trigram matching";
147 LOG(WARNING) << "-> Consider installing the \"pg_trgm\" extension on the "
148 << "PostgreSQL server, e.g. on Debian: sudo apt install postgresql-contrib";
144 } 149 }
145 } 150 }
146 151
147 if (revision != 1) 152 if (revision != 1)
148 { 153 {