Revision 14132
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 340 | 340 |
ALTER TABLE "TNRS".taxon_match DISABLE TRIGGER taxon_match__fill; --speeds up update |
| 341 | 341 |
UPDATE "TNRS".taxon_match SET "col" = value; |
| 342 | 342 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
| 343 |
CLUSTER "TNRS".taxon_match; -- ensure rows are exported in sorted order |
|
| 343 | 344 |
ALTER TABLE "TNRS".taxon_match ENABLE TRIGGER taxon_match__fill; |
| 344 | 345 |
VACUUM ANALYZE "TNRS".taxon_match --remove previous rows; runtime: 1.5 min ("92633 ms")
|
| 345 | 346 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19452 | 19452 |
ALTER TABLE "TNRS".taxon_match DISABLE TRIGGER taxon_match__fill; --speeds up update |
| 19453 | 19453 |
UPDATE "TNRS".taxon_match SET "col" = value; |
| 19454 | 19454 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
| 19455 |
CLUSTER "TNRS".taxon_match; -- ensure rows are exported in sorted order |
|
| 19455 | 19456 |
ALTER TABLE "TNRS".taxon_match ENABLE TRIGGER taxon_match__fill; |
| 19456 | 19457 |
VACUUM ANALYZE "TNRS".taxon_match --remove previous rows; runtime: 1.5 min ("92633 ms")
|
| 19457 | 19458 |
|
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: taxon_match: to populate a new column: also need to recluster table so rows are exported in sorted order