Revision 7455
Added by ben leinfelder over 11 years ago
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
additional db indexes for pathquery performance
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696