Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 3409 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Added %.backup/test
  bin 3406 over 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: If first arg is "all", dump en...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3387 over 12 years Aaron Marcuse-Kubitza input.Makefile: Mapping: $(map): Fixed bug wher...
  lib 3411 over 12 years Aaron Marcuse-Kubitza sql.py: distinct_table(): Removed literal value...
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3412 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: namedplace, plantname: *_u...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.4 KB 3393 over 12 years Aaron Marcuse-Kubitza Moved archived imports and make targets to main...
README.TXT 3.71 KB 3410 over 12 years Aaron Marcuse-Kubitza README.TXT: Maintenance: Full DB: Documented ho...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3412 07/17/2012 04:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: namedplace, plantname: *_unique UNIQUE INDEX: Reordered columns to put rank after parent_id and plantname so that these columns, which are usually input table columns, can be used in a merge join index scan, while rank, which is usually a literal value, can applied as an index filter condition after the merge join

3411 07/17/2012 04:42 PM Aaron Marcuse-Kubitza

sql.py: distinct_table(): Removed literal values from UNIQUE INDEXes because the query planner did not seem to use them to do a merge join

3410 07/17/2012 04:01 PM Aaron Marcuse-Kubitza

README.TXT: Maintenance: Full DB: Documented how to test full DB backup

3409 07/17/2012 03:47 PM Aaron Marcuse-Kubitza

backups/Makefile: Added %.backup/test

3408 07/16/2012 08:32 PM Aaron Marcuse-Kubitza

README.TXT: Documented maintenance of full DB (back up/restore)

3407 07/16/2012 08:23 PM Aaron Marcuse-Kubitza

backups/Makefile: Full DB backups: Added vegbien.backup

3406 07/16/2012 08:22 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: If first arg is "all", dump entire DB. Require a first arg so that Usage message will be displayed if run with no args.

3405 07/16/2012 08:03 PM Aaron Marcuse-Kubitza

Always output Usage messages to stderr and word-wrap them using `fold -s`

3404 07/16/2012 07:37 PM Aaron Marcuse-Kubitza

backups/Makefile: Factored backup command into $(backup) for later use by full DB backups. Made Backups, Archived imports sections subsections of Archived imports so Full DB backups can have its own section.

3403 07/16/2012 07:16 PM Aaron Marcuse-Kubitza

backups/Makefile: Fixed bug where $(SHELL) needed to be set to bash so that $'\n' would be interpreted correctly

View all revisions | View revisions

Also available in: Atom