Mercurial > gemma
view 3rdpartylibs.sh @ 4449:ce884af9f42f
Fix forecast accuracy values and improve performance
Forecast accuracy should be based only on the most recent predictions.
Generally consider measurements and predictions older than 14 days as
outdated and irrelevant. This also implies a performance gain, since it
saves a full scan of gauge_measurements and the extra index for this
purpose.
Adding an extra subquery level for calculation of the forecast accuracy per
row instead of the function call as a FROM item saves a (nested loop)
join, which is another performance gain.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 20 Sep 2019 13:22:45 +0200 |
parents | 5826d4de0e40 |
children |
line wrap: on
line source
#!/bin/sh # pgx hase undergone some major incompatible changes in v4, # we need to stick to v3 for now... # Unfortunatly using gopkg.in does not work as expected here, so lets # get hackisch... go get -u -v gopkg.in/jackc/pgx.v3 oldcwd="$CWD" cd "$GOPATH"/src/github.com/jackc/pgx git checkout v3.6.0 cd "$oldcwd" # MIT go get -u -v github.com/etcd-io/bbolt/... # MIT go get -u -v github.com/mitchellh/go-homedir # MIT go get -u -v github.com/spf13/cobra # Apache-2.0 go get -u -v github.com/spf13/viper # MIT go get -u -v github.com/gorilla/mux # BSD-3-Clause go get -u -v gopkg.in/gomail.v2 # MIT go get -u -v github.com/rs/cors # MIT go get -u -v golang.org/x/net/html/charset # Go License (aka BSD-3-Clause?) go get -u -v github.com/golang/snappy # BSD-3-Clause go get -u -v github.com/jonas-p/go-shp # MIT go get -u -v gopkg.in/robfig/cron.v1 # MIT go get -u -v github.com/tidwall/rtree # MIT go get -u -v golang.org/x/sync/semaphore # Go License (aka BSD-3-Clause?) go get -u -v gonum.org/v1/gonum/stat # BSD-3-Clause go get -u -v github.com/sergi/go-diff/diffmatchpatch # MIT # Only used in tests. # Only needed when generating SVG graphics for debugging. # go get -u -v github.com/ajstarks/svgo # Attribution 3.0 United States (CC BY 3.0 US) ## list of additional licenses that get fetched and installed as dependencies # github.com/fsnotify/fsnotify/ BSD-3-Clause # github.com/hashicorp/hcl/ MPL-2.0 # github.com/magiconair/properties/ BSD-2-Clause # github.com/mitchellh/go-homedir/ MIT # github.com/mitchellh/mapstructure MIT # github.com/pelletier/go-toml/ MIT # github.com/pkg/errors BSD-2-Clause # github.com/spf13/afero/ Apache 2.0 # github.com/spf13/cast MIT # github.com/spf13/jwalterweatherman MIT # gopkg.in/yaml.v2/#