Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  FIA 12678 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/plots/FIA/bien3_validati...
  SALVIAS 13103 over 10 years Aaron Marcuse-Kubitza removed old version validation/aggregating/plot...
  VegBank 13400 over 10 years Aaron Marcuse-Kubitza added validation/aggregating/plots/VegBank/bien...
  _archive 12061 almost 11 years Aaron Marcuse-Kubitza validation/**: removed by=... indicators so tha...
bien3_validations_salvias_vegbien.sql 21.3 KB 13404 over 10 years Aaron Marcuse-Kubitza validation/aggregating/plots/bien3_validations_...

Latest revisions

# Date Author Comment
13404 05/03/2014 03:17 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed disabling of enable_hashjoin (the lack of an additional join now makes `SET enable_seqscan = off;` sufficient to prevent a slow hash join)

13400 05/03/2014 12:44 PM Aaron Marcuse-Kubitza

added validation/aggregating/plots/VegBank/bien3_validations_salvias_db_original_adjToVegBank.txt from Mike Lee

13399 05/03/2014 01:39 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB

13395 05/03/2014 12:47 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed setting of join_collapse_limit (the column now used does not involve an additional join)

13394 05/02/2014 11:34 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _plots_21_tnrs_output_names: use scrubbed_unique_taxon_name (concatenated output name) because this is more similar to the concatenated name used in _plots_20_tnrs_input_names

13393 05/02/2014 11:22 PM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: needs to be run with `SET join_collapse_limit = DEFAULT; SET enable_hashjoin = off;` to produce the right query plan

13391 05/02/2014 10:42 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB

13103 04/10/2014 06:38 AM Aaron Marcuse-Kubitza

removed old version validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.sql. use validation/aggregating/plots/SALVIAS/_archive/bien3_validations_salvias_db_original.sql instead.

13061 04/07/2014 05:35 PM Aaron Marcuse-Kubitza

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()

12923 03/27/2014 03:57 AM Aaron Marcuse-Kubitza

validation/**.sql: replaced CREATE OR REPLACE VIEW with CREATE VIEW to match pg_dump output for diffing

View revisions

Also available in: Atom