Project

General

Profile

« Previous | Next » 

Revision 10334

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/REMIB/Specimen/postprocess.sql: removed coll_year, country, long_deg indexes because the frameshift filter conditions on these columns do not use index scans (because their regexp patterns do not contain a fixed prefix). eventually, some regexp patterns may be able to be modified to use prefixes.

View differences:

inputs/REMIB/Specimen/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym"   ON $$||:table_str||$$ (acronym)$$);


  		




  4
  
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.coll_year" ON $$||:table_str||$$ (coll_year)$$);


  		




  5
  
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.country"   ON $$||:table_str||$$ (country)$$);


  		




  6
  
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.long_deg"  ON $$||:table_str||$$ (long_deg)$$);


  		




  
  3
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ (acronym)$$);


  		




  7
  4
  
    

  		




  8
  5
  
    
-- remove frameshifted rows


  		




  9
  6
  
    
-- rerun time: 6 s ("Time: 5537.211 ms") thanks to index


  		












Also available in:  Unified diff