Revision 9993
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 89 | 89 |
/* IMPORTANT: when changing this function, you must regenerate the derived cols: |
| 90 | 90 |
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted" |
| 91 | 91 |
runtime: 16 min ("5052509 rows affected, 980692 ms execution time")
|
| 92 |
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows |
|
| 93 |
runtime: 50 s ("48264 ms")
|
|
| 92 | 94 |
*/ |
| 93 | 95 |
CREATE OR REPLACE FUNCTION tnrs_populate_fields() |
| 94 | 96 |
RETURNS trigger AS |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_populate_fields(): added VACUUM ANALYZE and runtime (50 s)