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 13931 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/input.Makefile: sql/install: sch...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
13931 07/09/2014 07:03 AM Aaron Marcuse-Kubitza

bugfix: inputs/input.Makefile: sql/install: schema.sql should not be passed through pg_dump_limit because it contains GRANT statements that need to be run

13930 07/09/2014 06:22 AM Aaron Marcuse-Kubitza

schemas/public_.sql: iucn_red_list_view: documented how to regenerate iucn_red_list from this

13929 07/08/2014 04:17 PM Aaron Marcuse-Kubitza

exports/2014-6-4.Iara_Lacher.reserve_prioritization.csv.run: documented runtime (7.5 min) and rowcount (3.5 million)

13928 07/08/2014 03:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: fixed slowdown in materializing the view, which was caused by source__observation_type(), by replacing this with a LEFT JOIN as was done for is_threatened_iucn

13927 07/07/2014 07:33 AM Aaron Marcuse-Kubitza

schemas/util.sql: in_south_america(): optimized by using BETWEEN instead of util.contained_within__no_dateline(). this reduces the filter time for 2014-6-4.Iara_Lacher.reserve_prioritization by about 10%.

13926 07/07/2014 07:26 AM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: is_threatened_iucn: generate this much faster by doing a LEFT JOIN, which can reuse the same in-memory hash index for every row

13925 07/07/2014 07:04 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: wrapper functions can't use util-schema types because these will cause the wrapper function to be cascadingly dropped when the util schema is reinstalled

13924 07/07/2014 06:55 AM Aaron Marcuse-Kubitza

bugfix: in_south_america(): must use util.contained_within__no_dateline() instead of util.contained_within_approx() to ensure that the more accurate geometry logic is used

13923 07/07/2014 06:51 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: source__observation_type(): don't display NOTICEs about the search_path, because this function will be called millions of times

13922 07/07/2014 06:48 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: in_iucn_red_list(): don't display NOTICEs about the search_path, because this function will be called millions of times

View all revisions | View revisions

Also available in: Atom