Revision 14481
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3350 | 3350 |
|
| 3351 | 3351 |
|
| 3352 | 3352 |
-- |
| 3353 |
-- Name: TABLE `viewFullOccurrence_individual`; Type: COMMENT; Schema: public; Owner: - |
|
| 3354 |
-- |
|
| 3355 |
|
|
| 3356 |
|
|
| 3357 |
|
|
| 3358 |
|
|
| 3359 |
-- |
|
| 3353 | 3360 |
-- Name: COLUMN `viewFullOccurrence_individual`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 3354 | 3361 |
-- |
| 3355 | 3362 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 5675 | 5675 |
|
| 5676 | 5676 |
|
| 5677 | 5677 |
-- |
| 5678 |
-- Name: TABLE "viewFullOccurrence_individual"; Type: COMMENT; Schema: public; Owner: - |
|
| 5679 |
-- |
|
| 5680 |
|
|
| 5681 |
COMMENT ON TABLE "viewFullOccurrence_individual" IS ' |
|
| 5682 |
after updating this: |
|
| 5683 |
SELECT viewFullOccurrence_individual_view_modify() |
|
| 5684 |
add applicable columns to analytical_specimen, analytical_plot |
|
| 5685 |
|
|
| 5686 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
|
| 5687 |
|
|
| 5688 |
CREATE INDEX runtime: |
|
| 5689 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
|
| 5690 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 5691 |
2-column: ~2 h ((datasource, scrubbed_species_binomial_with_morphospecies): |
|
| 5692 |
"2:11:31") @r14089 @vegbiendev |
|
| 5693 |
'; |
|
| 5694 |
|
|
| 5695 |
|
|
| 5696 |
-- |
|
| 5678 | 5697 |
-- Name: COLUMN "viewFullOccurrence_individual"."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5679 | 5698 |
-- |
| 5680 | 5699 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 5675 | 5675 |
|
| 5676 | 5676 |
|
| 5677 | 5677 |
-- |
| 5678 |
-- Name: TABLE "viewFullOccurrence_individual"; Type: COMMENT; Schema: public; Owner: - |
|
| 5679 |
-- |
|
| 5680 |
|
|
| 5681 |
COMMENT ON TABLE "viewFullOccurrence_individual" IS ' |
|
| 5682 |
after updating this: |
|
| 5683 |
SELECT viewFullOccurrence_individual_view_modify() |
|
| 5684 |
add applicable columns to analytical_specimen, analytical_plot |
|
| 5685 |
|
|
| 5686 |
materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev
|
|
| 5687 |
|
|
| 5688 |
CREATE INDEX runtime: |
|
| 5689 |
1-column: 10 min - 1.5 h depending on the datatype and % populated |
|
| 5690 |
(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev |
|
| 5691 |
2-column: ~2 h ((datasource, scrubbed_species_binomial_with_morphospecies): |
|
| 5692 |
"2:11:31") @r14089 @vegbiendev |
|
| 5693 |
'; |
|
| 5694 |
|
|
| 5695 |
|
|
| 5696 |
-- |
|
| 5678 | 5697 |
-- Name: COLUMN "viewFullOccurrence_individual"."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5679 | 5698 |
-- |
| 5680 | 5699 |
|
Also available in: Unified diff
schemas/public_.sql: viewFullOccurrence_individual: re-ran viewFullOccurrence_individual_view_modify() to udpate this