Project

General

Profile

Revision 8393

add indices for access log performance during upgrade to 2.3.0.

View differences:

upgrade-db-to-2.3.0-postgres.sql
1 1
/*
2
 * Add indices for log access 
3
 */
4
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
5
CREATE INDEX access_log_docid ON access_log(docid);
6

  
7
/*
2 8
 * update the database version
3 9
 */
4 10
UPDATE db_version SET status=0;

Also available in: Unified diff