Revision 11615
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/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
inputs/.TNRS/schema.sql: tnrs_populate_fields(): regenerate the derived cols: updated runtimes (~same)