Project

General

Profile

« Previous | Next » 

Revision 11615

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): regenerate the derived cols: updated runtimes (~same)

View differences:

schema.sql
143 143 

  		




  144
  144
  
    
COMMENT ON FUNCTION tnrs_populate_fields() IS 'IMPORTANT: when changing this function, you must regenerate the derived cols:


  		




  145
  145
  
    
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"


  		




  146
  
  
    
runtime: 25 min ("5221748 rows affected, 1524228 ms execution time")


  		




  
  146
  
    
runtime: 25 min ("5363526 rows affected, 1351907 ms execution time")


  		




  147
  147
  
    
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows


  		




  148
  
  
    
runtime: 1 min ("62350 ms")';


  		




  
  148
  
    
runtime: 1.5 min ("92633 ms")';


  		




  149
  149
  
    

  		




  150
  150
  
    

  		




  151
  151
  
    
SET default_tablespace = '';


  		












Also available in:  Unified diff