Revision 14473
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9159 | 9159 |
-- |
| 9160 | 9160 |
|
| 9161 | 9161 |
COMMENT ON VIEW "viewFullOccurrence_individual_view" IS ' |
| 9162 |
after updating this: |
|
| 9163 |
SELECT viewFullOccurrence_individual_view_modify() |
|
| 9164 |
add applicable columns to analytical_specimen, analytical_plot |
|
| 9165 |
|
|
| 9162 | 9166 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
| 9163 | 9167 |
|
| 9164 | 9168 |
CREATE INDEX runtime: 10 min - 1.5 h depending on the datatype and % populated |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9159 | 9159 |
-- |
| 9160 | 9160 |
|
| 9161 | 9161 |
COMMENT ON VIEW "viewFullOccurrence_individual_view" IS ' |
| 9162 |
after updating this: |
|
| 9163 |
SELECT viewFullOccurrence_individual_view_modify() |
|
| 9164 |
add applicable columns to analytical_specimen, analytical_plot |
|
| 9165 |
|
|
| 9162 | 9166 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
| 9163 | 9167 |
|
| 9164 | 9168 |
CREATE INDEX runtime: 10 min - 1.5 h depending on the datatype and % populated |
Also available in: Unified diff
schemas/public_.sql: viewFullOccurrence_individual_view: added "after updating this" instructions