Revision 12619
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 4246 | 4246 |
COMMENT ON TABLE locationevent IS ' |
| 4247 | 4247 |
Equivalent to VegBank''s observation table. |
| 4248 | 4248 |
|
| 4249 |
`VACUUM ANALYZE VERBOSE locationevent` runtime: 20 min ("1188590 ms") @vegbiendev
|
|
| 4249 | 4250 |
`UPDATE locationevent SET place_visit_id = place_visit_id` runtime: >~1 h @vegbiendev |
| 4250 | 4251 |
'; |
| 4251 | 4252 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: documented `VACUUM ANALYZE` runtime (20 min)