Revision 11715
Added by Aaron Marcuse-Kubitza about 11 years ago
| schema.sql | ||
|---|---|---|
| 155 | 155 |
|
| 156 | 156 |
COMMENT ON FUNCTION tnrs_populate_fields() IS 'IMPORTANT: when changing this function, you must regenerate the derived cols: |
| 157 | 157 |
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted" |
| 158 |
runtime: 40 min ("5363526 rows affected, 2329840 ms execution time")
|
|
| 158 |
runtime: 30 min ("5564082 rows affected, 1918900 ms execution time")
|
|
| 159 | 159 |
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows |
| 160 | 160 |
runtime: 1.5 min ("92633 ms")';
|
| 161 | 161 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: updated runtime (30 min) and rowcount (+2 million)