Project

General

Profile

Revision 7455

additional db indexes for pathquery performance
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696

View differences:

upgrade-db-to-2.0.5-postgres.sql
5 5
ALTER TABLE systemMetadataReplicationStatus RENAME TO smReplicationStatus;
6 6

  
7 7
/*
8
 * Add some additional indexes for search
9
 */
10
CREATE INDEX xml_documents_idx5 ON xml_documents (docid, rev);
11

  
12
CREATE INDEX xml_access_idx6 on xml_access(guid);
13

  
14
CREATE INDEX identifier_guid on identifier(guid);
15
CREATE INDEX identifier_docid on identifier(docid);
16
CREATE INDEX identifier_rev on identifier(rev);
17
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
18

  
19
CREATE INDEX xml_path_index_idx6 ON xml_path_index (docid);
20

  
21
/*
8 22
 * update the database version
9 23
 */
10 24
UPDATE db_version SET status=0;

Also available in: Unified diff