Need help cloning? Visit
is a free Git and Mercurial client for Windows.
is a free Git and Mercurial client for Mac.
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
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.