Revision 13582
Added by Aaron Marcuse-Kubitza about 10 years ago
| schema.sql | ||
|---|---|---|
| 338 | 338 |
make the changes in inputs/.TNRS/schema.sql |
| 339 | 339 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 340 | 340 |
$ make schemas/remake |
| 341 |
|
|
| 342 |
to populate a new column: |
|
| 343 |
ALTER TABLE "TNRS".tnrs DISABLE TRIGGER tnrs_populate_fields; --speeds up update |
|
| 344 |
UPDATE "TNRS".tnrs SET "col" = value; |
|
| 345 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 346 |
ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields; |
|
| 347 |
VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
|
|
| 341 | 348 |
'; |
| 342 | 349 |
|
| 343 | 350 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: documented how to populate a new column