Revision 11647
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 142 | 142 |
|
| 143 | 143 |
COMMENT ON FUNCTION tnrs_populate_fields() IS 'IMPORTANT: when changing this function, you must regenerate the derived cols: |
| 144 | 144 |
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted" |
| 145 |
runtime: 25 min ("5363526 rows affected, 1351907 ms execution time")
|
|
| 145 |
runtime: 40 min ("5363526 rows affected, 2329840 ms execution time")
|
|
| 146 | 146 |
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows |
| 147 | 147 |
runtime: 1.5 min ("92633 ms")';
|
| 148 | 148 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_populate_fields(): regenerate the derived cols: updated runtime (40 min)