Revision 13584
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 345 | 345 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
| 346 | 346 |
ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields; |
| 347 | 347 |
VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
|
| 348 |
|
|
| 349 |
to add a constraint: runtime: 3 min ("173620 ms")
|
|
| 348 | 350 |
'; |
| 349 | 351 |
|
| 350 | 352 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17182 | 17182 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
| 17183 | 17183 |
ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields; |
| 17184 | 17184 |
VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
|
| 17185 |
|
|
| 17186 |
to add a constraint: runtime: 3 min ("173620 ms")
|
|
| 17185 | 17187 |
'; |
| 17186 | 17188 |
|
| 17187 | 17189 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: documented runtime to add a constraint (3 min)