{"action":"created","issue":{"url":"https://api.github.com/repos/18F/openFEC/issues/595","labels_url":"https://api.github.com/repos/18F/openFEC/issues/595/labels{/name}","comments_url":"https://api.github.com/repos/18F/openFEC/issues/595/comments","events_url":"https://api.github.com/repos/18F/openFEC/issues/595/events","html_url":"https://github.com/18F/openFEC/pull/595","id":70206438,"number":595,"title":"[hold] Refresh concurrently","user":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-22T18:51:21Z","updated_at":"2015-04-22T18:52:01Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/18F/openFEC/pulls/595","html_url":"https://github.com/18F/openFEC/pull/595","diff_url":"https://github.com/18F/openFEC/pull/595.diff","patch_url":"https://github.com/18F/openFEC/pull/595.patch"},"body":"This patch changes the refresh materialize views script so that views are refreshed concurrently, and views aren't locked during refresh. This requires postgres 9.4, so should *not* be merged until / unless the rds instances are using the latest version. Concurrent refresh also requires that each view has at least one unique index, so I added a dummy row counter to each view."},"comment":{"url":"https://api.github.com/repos/18F/openFEC/issues/comments/95300330","html_url":"https://github.com/18F/openFEC/pull/595#issuecomment-95300330","issue_url":"https://api.github.com/repos/18F/openFEC/issues/595","id":95300330,"user":{"login":"arowla","id":166715,"avatar_url":"https://avatars.githubusercontent.com/u/166715?v=3","gravatar_id":"","url":"https://api.github.com/users/arowla","html_url":"https://github.com/arowla","followers_url":"https://api.github.com/users/arowla/followers","following_url":"https://api.github.com/users/arowla/following{/other_user}","gists_url":"https://api.github.com/users/arowla/gists{/gist_id}","starred_url":"https://api.github.com/users/arowla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arowla/subscriptions","organizations_url":"https://api.github.com/users/arowla/orgs","repos_url":"https://api.github.com/users/arowla/repos","events_url":"https://api.github.com/users/arowla/events{/privacy}","received_events_url":"https://api.github.com/users/arowla/received_events","type":"User","site_admin":false},"created_at":"2015-04-22T18:52:01Z","updated_at":"2015-04-22T18:52:01Z","body":"I am going to assign this to myself as a reminder to change over our RDS instances to 9.4."}}