Revision 13582
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/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 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17175 | 17175 |
make the changes in inputs/.TNRS/schema.sql |
| 17176 | 17176 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 17177 | 17177 |
$ make schemas/remake |
| 17178 |
|
|
| 17179 |
to populate a new column: |
|
| 17180 |
ALTER TABLE "TNRS".tnrs DISABLE TRIGGER tnrs_populate_fields; --speeds up update |
|
| 17181 |
UPDATE "TNRS".tnrs SET "col" = value; |
|
| 17182 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 17183 |
ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields; |
|
| 17184 |
VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
|
|
| 17178 | 17185 |
'; |
| 17179 | 17186 |
|
| 17180 | 17187 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: documented how to populate a new column