{"action":"created","comment":{"url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/comments/208916039","pull_request_review_id":144823600,"id":208916039,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwODkxNjAzOQ==","diff_hunk":"@@ -242,6 +242,27 @@ partitions=[\"/dev/sdc1\"]\n datavol_device='/dev/mapper/consolidated-data'\n postgresql_replication_slots=['standby','spare']\n \n+[pgwarehouse0]\n+10.247.164.92\n+\n+[pgwarehouse0:vars]\n+hostname='pgwarehouse0'\n+devices=[\"/dev/sdc\"]\n+partitions=[\"/dev/sdc1\"]\n+datavol_device='/dev/mapper/consolidated-data'\n+postgresql_replication_slots=['standby','spare']\n+pgbouncer_max_connections=3500\n+pgbouncer_default_pool=775\n+postgresql_max_connections=800\n+postgresql_work_mem=41943kB\n+postgresql_shared_buffers=8GB\n+postgresql_effective_cache_size=24GB\n+postgresql_maintenance_work_mem = 2GB\n+postgresql_checkpoint_segments=64\n+postgresql_checkpoint_completion_target=0.9\n+postgresql_wal_buffers=16MB\n+postgresql_default_statistics_target = 100","path":"environments/icds-new/inventory.ini","position":23,"original_position":23,"commit_id":"31573fe44e46cf8504488872358d2cb501e0d4e5","original_commit_id":"31573fe44e46cf8504488872358d2cb501e0d4e5","user":{"login":"calellowitz","id":6844721,"node_id":"MDQ6VXNlcjY4NDQ3MjE=","avatar_url":"https://avatars3.githubusercontent.com/u/6844721?v=4","gravatar_id":"","url":"https://api.github.com/users/calellowitz","html_url":"https://github.com/calellowitz","followers_url":"https://api.github.com/users/calellowitz/followers","following_url":"https://api.github.com/users/calellowitz/following{/other_user}","gists_url":"https://api.github.com/users/calellowitz/gists{/gist_id}","starred_url":"https://api.github.com/users/calellowitz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/calellowitz/subscriptions","organizations_url":"https://api.github.com/users/calellowitz/orgs","repos_url":"https://api.github.com/users/calellowitz/repos","events_url":"https://api.github.com/users/calellowitz/events{/privacy}","received_events_url":"https://api.github.com/users/calellowitz/received_events","type":"User","site_admin":false},"body":"updated to use pgtune with `warehouse` as the db type","created_at":"2018-08-09T12:50:18Z","updated_at":"2018-08-09T12:50:18Z","html_url":"https://github.com/dimagi/commcare-cloud/pull/1978#discussion_r208916039","pull_request_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/comments/208916039"},"html":{"href":"https://github.com/dimagi/commcare-cloud/pull/1978#discussion_r208916039"},"pull_request":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978"}},"in_reply_to_id":206466734},"pull_request":{"url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978","id":204740176,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA0NzQwMTc2","html_url":"https://github.com/dimagi/commcare-cloud/pull/1978","diff_url":"https://github.com/dimagi/commcare-cloud/pull/1978.diff","patch_url":"https://github.com/dimagi/commcare-cloud/pull/1978.patch","issue_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/1978","number":1978,"state":"open","locked":false,"title":"Ce/icds airflow","user":{"login":"calellowitz","id":6844721,"node_id":"MDQ6VXNlcjY4NDQ3MjE=","avatar_url":"https://avatars3.githubusercontent.com/u/6844721?v=4","gravatar_id":"","url":"https://api.github.com/users/calellowitz","html_url":"https://github.com/calellowitz","followers_url":"https://api.github.com/users/calellowitz/followers","following_url":"https://api.github.com/users/calellowitz/following{/other_user}","gists_url":"https://api.github.com/users/calellowitz/gists{/gist_id}","starred_url":"https://api.github.com/users/calellowitz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/calellowitz/subscriptions","organizations_url":"https://api.github.com/users/calellowitz/orgs","repos_url":"https://api.github.com/users/calellowitz/repos","events_url":"https://api.github.com/users/calellowitz/events{/privacy}","received_events_url":"https://api.github.com/users/calellowitz/received_events","type":"User","site_admin":false},"body":"@NitigyaS @snopoke @czue \r\nWork to setup the warehouse on ICDS","created_at":"2018-07-30T09:12:08Z","updated_at":"2018-08-09T12:50:18Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8b9ffdd59e814830e31fae69ea90664bec06d467","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978/commits","review_comments_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978/comments","review_comment_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/comments{/number}","comments_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/1978/comments","statuses_url":"https://api.github.com/repos/dimagi/commcare-cloud/statuses/31573fe44e46cf8504488872358d2cb501e0d4e5","head":{"label":"dimagi:ce/icds-airflow","ref":"ce/icds-airflow","sha":"31573fe44e46cf8504488872358d2cb501e0d4e5","user":{"login":"dimagi","id":94514,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk0NTE0","avatar_url":"https://avatars1.githubusercontent.com/u/94514?v=4","gravatar_id":"","url":"https://api.github.com/users/dimagi","html_url":"https://github.com/dimagi","followers_url":"https://api.github.com/users/dimagi/followers","following_url":"https://api.github.com/users/dimagi/following{/other_user}","gists_url":"https://api.github.com/users/dimagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dimagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimagi/subscriptions","organizations_url":"https://api.github.com/users/dimagi/orgs","repos_url":"https://api.github.com/users/dimagi/repos","events_url":"https://api.github.com/users/dimagi/events{/privacy}","received_events_url":"https://api.github.com/users/dimagi/received_events","type":"Organization","site_admin":false},"repo":{"id":22074543,"node_id":"MDEwOlJlcG9zaXRvcnkyMjA3NDU0Mw==","name":"commcare-cloud","full_name":"dimagi/commcare-cloud","owner":{"login":"dimagi","id":94514,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk0NTE0","avatar_url":"https://avatars1.githubusercontent.com/u/94514?v=4","gravatar_id":"","url":"https://api.github.com/users/dimagi","html_url":"https://github.com/dimagi","followers_url":"https://api.github.com/users/dimagi/followers","following_url":"https://api.github.com/users/dimagi/following{/other_user}","gists_url":"https://api.github.com/users/dimagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dimagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimagi/subscriptions","organizations_url":"https://api.github.com/users/dimagi/orgs","repos_url":"https://api.github.com/users/dimagi/repos","events_url":"https://api.github.com/users/dimagi/events{/privacy}","received_events_url":"https://api.github.com/users/dimagi/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/dimagi/commcare-cloud","description":"Tools for standing up and managing a CommCare HQ server environment","fork":false,"url":"https://api.github.com/repos/dimagi/commcare-cloud","forks_url":"https://api.github.com/repos/dimagi/commcare-cloud/forks","keys_url":"https://api.github.com/repos/dimagi/commcare-cloud/keys{/key_id}","collaborators_url":"https://api.github.com/repos/dimagi/commcare-cloud/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/dimagi/commcare-cloud/teams","hooks_url":"https://api.github.com/repos/dimagi/commcare-cloud/hooks","issue_events_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/events{/number}","events_url":"https://api.github.com/repos/dimagi/commcare-cloud/events","assignees_url":"https://api.github.com/repos/dimagi/commcare-cloud/assignees{/user}","branches_url":"https://api.github.com/repos/dimagi/commcare-cloud/branches{/branch}","tags_url":"https://api.github.com/repos/dimagi/commcare-cloud/tags","blobs_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/refs{/sha}","trees_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/trees{/sha}","statuses_url":"https://api.github.com/repos/dimagi/commcare-cloud/statuses/{sha}","languages_url":"https://api.github.com/repos/dimagi/commcare-cloud/languages","stargazers_url":"https://api.github.com/repos/dimagi/commcare-cloud/stargazers","contributors_url":"https://api.github.com/repos/dimagi/commcare-cloud/contributors","subscribers_url":"https://api.github.com/repos/dimagi/commcare-cloud/subscribers","subscription_url":"https://api.github.com/repos/dimagi/commcare-cloud/subscription","commits_url":"https://api.github.com/repos/dimagi/commcare-cloud/commits{/sha}","git_commits_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/commits{/sha}","comments_url":"https://api.github.com/repos/dimagi/commcare-cloud/comments{/number}","issue_comment_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/comments{/number}","contents_url":"https://api.github.com/repos/dimagi/commcare-cloud/contents/{+path}","compare_url":"https://api.github.com/repos/dimagi/commcare-cloud/compare/{base}...{head}","merges_url":"https://api.github.com/repos/dimagi/commcare-cloud/merges","archive_url":"https://api.github.com/repos/dimagi/commcare-cloud/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/dimagi/commcare-cloud/downloads","issues_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues{/number}","pulls_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls{/number}","milestones_url":"https://api.github.com/repos/dimagi/commcare-cloud/milestones{/number}","notifications_url":"https://api.github.com/repos/dimagi/commcare-cloud/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/dimagi/commcare-cloud/labels{/name}","releases_url":"https://api.github.com/repos/dimagi/commcare-cloud/releases{/id}","deployments_url":"https://api.github.com/repos/dimagi/commcare-cloud/deployments","created_at":"2014-07-21T18:04:26Z","updated_at":"2018-08-08T16:55:05Z","pushed_at":"2018-08-09T11:57:44Z","git_url":"git://github.com/dimagi/commcare-cloud.git","ssh_url":"git@github.com:dimagi/commcare-cloud.git","clone_url":"https://github.com/dimagi/commcare-cloud.git","svn_url":"https://github.com/dimagi/commcare-cloud","homepage":"https://dimagi.github.io/commcare-cloud/","size":9909,"stargazers_count":8,"watchers_count":8,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":true,"forks_count":11,"mirror_url":null,"archived":false,"open_issues_count":33,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":11,"open_issues":33,"watchers":8,"default_branch":"master"}},"base":{"label":"dimagi:master","ref":"master","sha":"304827b7f3e26c2429a69d1141e5e2366a7d669f","user":{"login":"dimagi","id":94514,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk0NTE0","avatar_url":"https://avatars1.githubusercontent.com/u/94514?v=4","gravatar_id":"","url":"https://api.github.com/users/dimagi","html_url":"https://github.com/dimagi","followers_url":"https://api.github.com/users/dimagi/followers","following_url":"https://api.github.com/users/dimagi/following{/other_user}","gists_url":"https://api.github.com/users/dimagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dimagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimagi/subscriptions","organizations_url":"https://api.github.com/users/dimagi/orgs","repos_url":"https://api.github.com/users/dimagi/repos","events_url":"https://api.github.com/users/dimagi/events{/privacy}","received_events_url":"https://api.github.com/users/dimagi/received_events","type":"Organization","site_admin":false},"repo":{"id":22074543,"node_id":"MDEwOlJlcG9zaXRvcnkyMjA3NDU0Mw==","name":"commcare-cloud","full_name":"dimagi/commcare-cloud","owner":{"login":"dimagi","id":94514,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk0NTE0","avatar_url":"https://avatars1.githubusercontent.com/u/94514?v=4","gravatar_id":"","url":"https://api.github.com/users/dimagi","html_url":"https://github.com/dimagi","followers_url":"https://api.github.com/users/dimagi/followers","following_url":"https://api.github.com/users/dimagi/following{/other_user}","gists_url":"https://api.github.com/users/dimagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dimagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimagi/subscriptions","organizations_url":"https://api.github.com/users/dimagi/orgs","repos_url":"https://api.github.com/users/dimagi/repos","events_url":"https://api.github.com/users/dimagi/events{/privacy}","received_events_url":"https://api.github.com/users/dimagi/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/dimagi/commcare-cloud","description":"Tools for standing up and managing a CommCare HQ server environment","fork":false,"url":"https://api.github.com/repos/dimagi/commcare-cloud","forks_url":"https://api.github.com/repos/dimagi/commcare-cloud/forks","keys_url":"https://api.github.com/repos/dimagi/commcare-cloud/keys{/key_id}","collaborators_url":"https://api.github.com/repos/dimagi/commcare-cloud/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/dimagi/commcare-cloud/teams","hooks_url":"https://api.github.com/repos/dimagi/commcare-cloud/hooks","issue_events_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/events{/number}","events_url":"https://api.github.com/repos/dimagi/commcare-cloud/events","assignees_url":"https://api.github.com/repos/dimagi/commcare-cloud/assignees{/user}","branches_url":"https://api.github.com/repos/dimagi/commcare-cloud/branches{/branch}","tags_url":"https://api.github.com/repos/dimagi/commcare-cloud/tags","blobs_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/refs{/sha}","trees_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/trees{/sha}","statuses_url":"https://api.github.com/repos/dimagi/commcare-cloud/statuses/{sha}","languages_url":"https://api.github.com/repos/dimagi/commcare-cloud/languages","stargazers_url":"https://api.github.com/repos/dimagi/commcare-cloud/stargazers","contributors_url":"https://api.github.com/repos/dimagi/commcare-cloud/contributors","subscribers_url":"https://api.github.com/repos/dimagi/commcare-cloud/subscribers","subscription_url":"https://api.github.com/repos/dimagi/commcare-cloud/subscription","commits_url":"https://api.github.com/repos/dimagi/commcare-cloud/commits{/sha}","git_commits_url":"https://api.github.com/repos/dimagi/commcare-cloud/git/commits{/sha}","comments_url":"https://api.github.com/repos/dimagi/commcare-cloud/comments{/number}","issue_comment_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues/comments{/number}","contents_url":"https://api.github.com/repos/dimagi/commcare-cloud/contents/{+path}","compare_url":"https://api.github.com/repos/dimagi/commcare-cloud/compare/{base}...{head}","merges_url":"https://api.github.com/repos/dimagi/commcare-cloud/merges","archive_url":"https://api.github.com/repos/dimagi/commcare-cloud/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/dimagi/commcare-cloud/downloads","issues_url":"https://api.github.com/repos/dimagi/commcare-cloud/issues{/number}","pulls_url":"https://api.github.com/repos/dimagi/commcare-cloud/pulls{/number}","milestones_url":"https://api.github.com/repos/dimagi/commcare-cloud/milestones{/number}","notifications_url":"https://api.github.com/repos/dimagi/commcare-cloud/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/dimagi/commcare-cloud/labels{/name}","releases_url":"https://api.github.com/repos/dimagi/commcare-cloud/releases{/id}","deployments_url":"https://api.github.com/repos/dimagi/commcare-cloud/deployments","created_at":"2014-07-21T18:04:26Z","updated_at":"2018-08-08T16:55:05Z","pushed_at":"2018-08-09T11:57:44Z","git_url":"git://github.com/dimagi/commcare-cloud.git","ssh_url":"git@github.com:dimagi/commcare-cloud.git","clone_url":"https://github.com/dimagi/commcare-cloud.git","svn_url":"https://github.com/dimagi/commcare-cloud","homepage":"https://dimagi.github.io/commcare-cloud/","size":9909,"stargazers_count":8,"watchers_count":8,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":true,"forks_count":11,"mirror_url":null,"archived":false,"open_issues_count":33,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":11,"open_issues":33,"watchers":8,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978"},"html":{"href":"https://github.com/dimagi/commcare-cloud/pull/1978"},"issue":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/issues/1978"},"comments":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/issues/1978/comments"},"review_comments":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978/comments"},"review_comment":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/pulls/1978/commits"},"statuses":{"href":"https://api.github.com/repos/dimagi/commcare-cloud/statuses/31573fe44e46cf8504488872358d2cb501e0d4e5"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"calellowitz"}}