Revision 14770
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/public_.sql | ||
---|---|---|
12134 | 12134 |
SELECT view_full_occurrence_individual_view_modify() |
12135 | 12135 |
add applicable columns to analytical_specimen, analytical_plot |
12136 | 12136 |
|
12137 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
|
12137 |
materialize time: 2 days (42 h; "152473233.340 ms") @r14089 @vegbiendev
|
|
12138 | 12138 |
|
12139 | 12139 |
CREATE INDEX runtime: |
12140 | 12140 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
trunk/schemas/vegbien.sql | ||
---|---|---|
12134 | 12134 |
SELECT view_full_occurrence_individual_view_modify() |
12135 | 12135 |
add applicable columns to analytical_specimen, analytical_plot |
12136 | 12136 |
|
12137 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
|
12137 |
materialize time: 2 days (42 h; "152473233.340 ms") @r14089 @vegbiendev
|
|
12138 | 12138 |
|
12139 | 12139 |
CREATE INDEX runtime: |
12140 | 12140 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
Also available in: Unified diff
schemas/public_.sql: view_full_occurrence_individual_view: materialize time: updated (2 days)