Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 7772 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN2/ERD/
  DiGIR 7767 over 11 years Aaron Marcuse-Kubitza Added schemas/DiGIR/gbif-occurrencestore.digir....
  DwC 8507 over 11 years Aaron Marcuse-Kubitza web/**/.htaccess: RewriteRules: ensured flags a...
  TAPIR 7789 over 11 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 about 11 years Aaron Marcuse-Kubitza schemas/VegBIEN/attribution/BIEN 3 data use and...
  VegBank 9671 over 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 12088 almost 11 years Aaron Marcuse-Kubitza schemas/VegCore/vegbien_identifier_examples.xls...
  VegX 12090 almost 11 years Aaron Marcuse-Kubitza removed schemas/VegX/run.py, which is a duplica...
.htaccess 349 Bytes 8514 over 11 years Aaron Marcuse-Kubitza bugfix: schemas/.htaccess: corrected $innermost...
BIEN_logo.png 165 KB 7740 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.png.url 61 Bytes 7740 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.small.png 9.84 KB 7739 over 11 years Aaron Marcuse-Kubitza Renamed schemas/BIEN_logo.png to BIEN_logo.smal...
Makefile 3.51 KB 12600 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/Makefile: `%/install: vegbien.s...
filter_ERD.csv 1.45 KB 7060 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sync_analytical_*_to_view(...
my.cnf 3.48 KB 9619 over 11 years Aaron Marcuse-Kubitza schemas/my.cnf: added innodb_file_per_table so ...
pg_hba.Mac.conf 4.64 KB 11662 about 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
pg_hba.conf 4.26 KB 11451 about 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 about 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
postgresql.Mac.conf.run 80 Bytes 10833 about 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.conf 21.5 KB 12620 over 10 years Aaron Marcuse-Kubitza schemas/postgresql.conf: log_min_messages: drop...
postgresql.conf.run 80 Bytes 10833 about 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.nimoy.conf 17.1 KB 2778 over 12 years Aaron Marcuse-Kubitza schemas/postgresql.nimoy.conf: shared_buffers: ...
py_util.sql 6.42 KB 12235 almost 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 about 12 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Updated for schem...
util.sql 95.4 KB 12595 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: create_if_not_exists(): also ...
vegbien.ERD.1_pg.pdf 749 KB 12051 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 157 KB 12606 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: _plots_18_list_of_subplots...
vegbien.ERD.pdf 596 KB 12051 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 623 KB 12051 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.poster.core.pdf 315 KB 6323 about 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.pdf
vegbien.ERD.poster.core.print_options.png 74 KB 6324 about 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.print_opt...
vegbien.ERD.poster.pdf 776 KB 6328 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.poster.pdf: Updated to 33x5...
vegbien.ERD.svg 1.42 MB 12051 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 298 KB 12614 over 10 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: location: added plot_...
vegbien.sql 476 KB 12621 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/vegbien.sql: source_by_shortnam...
  • svn:ignore: *.bak *.log

Latest revisions

# Date Author Comment
12621 03/06/2014 10:45 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): documented that in some cases, it is actually a bad idea to use a nested SELECT, because this will prevent Postgres from using an index scan (causing an equally bad slowdown as not inlining in cases where a nested SELECT is required).

12620 03/06/2014 10:26 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: log_min_messages: dropped the verbosity back down to the default, to avoid clogging up the logs

12619 03/06/2014 10:21 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: locationevent: documented `VACUUM ANALYZE` runtime (20 min)

12618 03/06/2014 09:51 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: log_min_messages: show what autovacuum is doing

12617 03/06/2014 09:40 PM Aaron Marcuse-Kubitza

fix: schemas/postgresql.conf: disable autovacuum_vacuum_cost_delay to avoid stalling autovacuuming due to a concurrent query, as this can prevent autovacuuming from happening altogether (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Resource%20Consumption:%2018.4.4.%20Cost-based%20Vacuum%20Delay)

12615 03/06/2014 07:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: documented `CREATE INDEX plot_source_id` runtime (5 min)

12614 03/06/2014 07:30 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: location: added plot_source_id index to provide the equivalent of the location.source_id index for outer plots. this will help Postgres choose the right query plans in queries involving outer plots.

12606 03/06/2014 08:57 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _plots_18_list_of_subplots_codes_for_each_plot_for_each_project: added ~type table

12604 03/06/2014 08:31 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro: added ~type table

12600 03/06/2014 02:18 AM Aaron Marcuse-Kubitza

bugfix: schemas/Makefile: `%/install: vegbien.sql`: also need to match `public_validations` when used as a schema-qualifier (public_validations._), and after a cast (::) to a schema-qualified type. these occur in schema-qualified casts to the custom return type in the keys() functions.

View revisions

Also available in: Atom