Pull requests

#1 Open
Repository
matthewsomerville matthewsomerville
Branch
master
Repository
publicwhip publicwhip
Branch
master

Performance improvements

Bitbucket cannot automatically merge this request due to conflicts.

Review the conflicts on the Overview tab. You can then either decline the request or merge it manually on your local system using the following commands:

git checkout master
git remote add matthewsomerville/publicwhip-v1 https://bitbucket.org/matthewsomerville/publicwhip-v1.git
git fetch matthewsomerville/publicwhip-v1
git merge --no-ff -m 'Merged in matthewsomerville/publicwhip-v1 (pull request #1)' remotes/matthewsomerville/publicwhip-v1/master
Author
  1. matthewsomerville
Reviewers
Description

These should help with various bits of the loading scripts. Regular ANALYZE TABLEs will also help, pw_vote gets new stuff every day, and the query planner was well out of the loop.

The calc_caches now takes around 6 minutes, rather than hours+ it seemed to be taking.

Also fix a missing variable assignment.

Comments (0)