Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 12642 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: implemented _plots_08_list...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12642 03/12/2014 03:04 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: implemented _plots_08_list_of_plots_which_use_percent_cover

12641 03/12/2014 12:04 AM Aaron Marcuse-Kubitza

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

12640 03/12/2014 12:01 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: implemented _plots_07_list_of_plots_which_use_counts_of_indiv_per_species

12639 03/11/2014 09:57 PM Aaron Marcuse-Kubitza

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

12638 03/11/2014 09:56 PM Aaron Marcuse-Kubitza

bugfix: inputs/SALVIAS/validations.sql: plots_07_list_of_plots_with_counts_of_individuals_per_species: renamed to _plots_07_list_of_plots*which_use*_... because this query is not intended to include the actual counts, just to say which plots have them (the correct "which use" wording is also used in queries #8, 9)

12637 03/11/2014 04:05 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: query planner: documented how to prevent incorrect query plans (`SET enable_seqscan = off;`, etc.)

12636 03/11/2014 03:38 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: query planner: documented that incorrect query plans are an ongoing bug in Postgres, because it does not support index hints and by default does not follow the join order. specifically, Postgres often does the following things in query plans which should normally never be done:...

12635 03/07/2014 10:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql, inputs/SALVIAS/validations.sql: added _plots_06a_list_of_stems, for use in figuring out the diff in _plots_06_list_of_plots_with_stem_measurements

12634 03/07/2014 09:53 PM Aaron Marcuse-Kubitza

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

12633 03/07/2014 09:50 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plot: removed explicit column lists added in the autorename of plot.location_id->plot_id

View all revisions | View revisions

Also available in: Atom