Revision 14132
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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