Revision 14478
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9165 | 9165 |
|
| 9166 | 9166 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
| 9167 | 9167 |
|
| 9168 |
CREATE INDEX runtime: 10 min - 1.5 h depending on the datatype and % populated |
|
| 9169 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 9168 |
CREATE INDEX runtime: |
|
| 9169 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
|
| 9170 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 9171 |
2-column: ~2 h ((datasource, scrubbed_species_binomial_with_morphospecies): |
|
| 9172 |
"2:11:31") @r14089 @vegbiendev |
|
| 9170 | 9173 |
'; |
| 9171 | 9174 |
|
| 9172 | 9175 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9165 | 9165 |
|
| 9166 | 9166 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
| 9167 | 9167 |
|
| 9168 |
CREATE INDEX runtime: 10 min - 1.5 h depending on the datatype and % populated |
|
| 9169 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 9168 |
CREATE INDEX runtime: |
|
| 9169 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
|
| 9170 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 9171 |
2-column: ~2 h ((datasource, scrubbed_species_binomial_with_morphospecies): |
|
| 9172 |
"2:11:31") @r14089 @vegbiendev |
|
| 9170 | 9173 |
'; |
| 9171 | 9174 |
|
| 9172 | 9175 |
|
Also available in: Unified diff
schemas/public_.sql: viewFullOccurrence_individual_view: CREATE INDEX runtime: documented 2-column runtime (~2 h)