Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 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
  bin 3254 over 12 years Aaron Marcuse-Kubitza mk_rm_indexes: Also include the search_path in ...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3253 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: commclass: Fixed bug where...
  lib 3258 over 12 years Aaron Marcuse-Kubitza sql.py: run_query(): EXPLAIN all explainable qu...
  mappings 3229 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Sort the plant...
  schemas 3253 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: commclass: Fixed bug where...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.5 KB 3249 over 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: Added schem...
README.TXT 2.96 KB 3205 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Import data into VegBI...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3258 07/06/2012 04:29 PM Aaron Marcuse-Kubitza

sql.py: run_query(): EXPLAIN all explainable queries before they are run, to provide query plans for later profiling and index analysis. At verbosity 3+, this also effectively allows the user to see what query is being run before it's executed.

3257 07/06/2012 04:26 PM Aaron Marcuse-Kubitza

sql.py: is_explainable(): Fixed bug where needed r'' syntax to escape \ in \b

3256 07/06/2012 04:23 PM Aaron Marcuse-Kubitza

sql.py: Added explain() and is_explainable()

3255 07/06/2012 04:19 PM Aaron Marcuse-Kubitza

strings.py: Added join_lines()

3254 07/06/2012 02:50 PM Aaron Marcuse-Kubitza

mk_rm_indexes: Also include the search_path in the outputted commands

3253 07/06/2012 02:45 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: commclass: Fixed bug where commclass_unique needed to be a UNIQUE INDEX

3252 07/06/2012 02:42 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantname: Removed unneeded indexes on plantname and rank (plantname_unique takes care of joins)

3251 07/06/2012 02:33 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Enclose the schema name in "" because pg_dump requires this for schema names with special characters

3250 07/06/2012 02:09 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with stats from 2012-7-3 and 2012-7-5 imports. Note that the 2012-7-5 import was partial, so its stats can't be directly compared.

3249 07/06/2012 01:28 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: Added schemas/%/rm_indexes

View all revisions | View revisions

Also available in: Atom