Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 7772 about 12 years Aaron Marcuse-Kubitza Added schemas/BIEN2/ERD/
  DiGIR 7767 about 12 years Aaron Marcuse-Kubitza Added schemas/DiGIR/gbif-occurrencestore.digir....
  DwC 8507 almost 12 years Aaron Marcuse-Kubitza web/**/.htaccess: RewriteRules: ensured flags a...
  TAPIR 7789 about 12 years Aaron Marcuse-Kubitza Added schemas/TAPIR/SpeciesLink.tapir_request.t...
  TCS 10656 over 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
  VegBIEN 11281 over 11 years Aaron Marcuse-Kubitza schemas/VegBIEN/attribution/BIEN 3 data use and...
  VegBank 9671 almost 12 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 12088 about 11 years Aaron Marcuse-Kubitza schemas/VegCore/vegbien_identifier_examples.xls...
  VegX 12090 about 11 years Aaron Marcuse-Kubitza removed schemas/VegX/run.py, which is a duplica...
.htaccess 349 Bytes 8514 almost 12 years Aaron Marcuse-Kubitza bugfix: schemas/.htaccess: corrected $innermost...
BIEN_logo.png 165 KB 7740 about 12 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.png.url 61 Bytes 7740 about 12 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.small.png 9.84 KB 7739 about 12 years Aaron Marcuse-Kubitza Renamed schemas/BIEN_logo.png to BIEN_logo.smal...
Makefile 3.46 KB 12146 about 11 years Aaron Marcuse-Kubitza schemas/Makefile: vegbien.sql: support auxiliar...
filter_ERD.csv 1.45 KB 7060 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sync_analytical_*_to_view(...
my.cnf 3.48 KB 9619 almost 12 years Aaron Marcuse-Kubitza schemas/my.cnf: added innodb_file_per_table so ...
pg_hba.Mac.conf 4.64 KB 11662 over 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
pg_hba.conf 4.26 KB 11451 over 11 years Aaron Marcuse-Kubitza bugfix: schemas/pg_hba.conf: don't allow ident ...
pg_ident.Mac.conf 1.65 KB 10122 over 11 years Aaron Marcuse-Kubitza schemas/pg_ident.Mac.conf: added postgres map m...
postgresql.Mac.conf 20.7 KB 11662 over 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
postgresql.Mac.conf.run 80 Bytes 10833 over 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.conf 21.2 KB 11797 over 11 years Aaron Marcuse-Kubitza schemas/postgresql.conf: work_mem: documented t...
postgresql.conf.run 80 Bytes 10833 over 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.nimoy.conf 17.1 KB 2778 almost 13 years Aaron Marcuse-Kubitza schemas/postgresql.nimoy.conf: shared_buffers: ...
py_util.sql 6.42 KB 12235 about 11 years Aaron Marcuse-Kubitza schemas/*.sql: make sure every COMMENT starts a...
temp.sql 357 Bytes 2980 over 12 years Aaron Marcuse-Kubitza Added temp schema to store intermediate tables ...
tree_cross-links.sql 4.69 KB 5829 over 12 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Updated for schem...
util.sql 91.8 KB 12514 about 11 years Aaron Marcuse-Kubitza schemas/util.sql: eval2val(): made it STABLE so...
vegbien.ERD.1_pg.pdf 749 KB 12051 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 156 KB 12522 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: location.top_plot: renamed...
vegbien.ERD.pdf 596 KB 12051 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 623 KB 12051 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.poster.core.pdf 315 KB 6323 over 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.pdf
vegbien.ERD.poster.core.print_options.png 74 KB 6324 over 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.print_opt...
vegbien.ERD.poster.pdf 776 KB 6328 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.poster.pdf: Updated to 33x5...
vegbien.ERD.svg 1.42 MB 12051 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 284 KB 12523 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: top_plot view: renamed to ...
vegbien.sql 440 KB 12523 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: top_plot view: renamed to ...
  • svn:ignore: *.bak *.log

Latest revisions

# Date Author Comment
12523 02/27/2014 04:37 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: top_plot view: renamed to plot, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)

12522 02/27/2014 04:12 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)

12521 02/27/2014 03:51 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)

12520 02/27/2014 02:20 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: source_by_shortname(): documented exact time that the slow query ran for (5013s = ~1.5 hours)

12519 02/27/2014 02:07 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations: schema comment: documented how to sync the queries with schemas/vegbien.sql

12518 02/27/2014 02:05 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations.rm_all_queries(): when called with no args, operate on public_validations instead of all schemas, since this is the more common use case (replacing just the output queries, not both input and output)

12517 02/27/2014 01:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: rm_query_group(): documented that this only removes validations output queries (in public_validations), as it is designed for use in updating all output queries at once from the testing DB

12516 02/27/2014 01:27 PM Aaron Marcuse-Kubitza

bugfix: *.sql: public.source_by_shortname(): need to wrap it in a nested SELECT because Postgres incorrectly does not constant-fold (inline) it, leading to a slowdown when it is therefore run many times. this is done using the steps at wiki.vegpath.org/Postgres_queries#wrap-function-call-in-nested-SELECT .

12515 02/27/2014 12:43 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: source_by_shortname(): documented that it must be run as a nested SELECT, because otherwise Postgres will not inline it. not inlining causes the query to be run for each row in a table of potentially millions, and creates a significant slowdown (eg. >1.5 hours for SALVIAS._plots_06_list_of_plots_with_stem_measurements)

12514 02/27/2014 07:59 AM Aaron Marcuse-Kubitza

schemas/util.sql: eval2val(): made it STABLE so that functions that use it can themselves be inlined. (Postgres apparently ignores the STABLE qualifier, without warning, if the function contains any VOLATILE statements.)

View revisions

Also available in: Atom