Project

General

Profile

Revision 8335

add 2 indexes to speed up dataONE log retrieval. https://projects.ecoinformatics.org/ecoinfo/issues/6161

View differences:

xmltables-postgres.sql
289 289
CREATE INDEX identifier_docid on identifier(docid);
290 290
CREATE INDEX identifier_rev on identifier(rev);
291 291
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
292
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
292 293

  
293 294
/*
294 295
 * Table used to store all document identifiers for system metadata objects
......
401 402
  date_logged   TIMESTAMP,      -- the datetime on which the event occurred
402 403
  CONSTRAINT access_log_pk PRIMARY KEY (entryid)
403 404
);
405
CREATE INDEX access_log_docid ON access_log(docid);
404 406

  
407

  
405 408
/*
406 409
 * the index_event table for solr-based indexing
407 410
 */

Also available in: Unified diff