{"action":"created","issue":{"url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/139","labels_url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/139/labels{/name}","comments_url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/139/comments","events_url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/139/events","html_url":"https://github.com/dimagi/commcarehq-ansible/pull/139","id":82559857,"number":139,"title":"Setup for pgbench host and runner server","user":{"login":"benrudolph","id":918514,"avatar_url":"https://avatars.githubusercontent.com/u/918514?v=3","gravatar_id":"","url":"https://api.github.com/users/benrudolph","html_url":"https://github.com/benrudolph","followers_url":"https://api.github.com/users/benrudolph/followers","following_url":"https://api.github.com/users/benrudolph/following{/other_user}","gists_url":"https://api.github.com/users/benrudolph/gists{/gist_id}","starred_url":"https://api.github.com/users/benrudolph/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benrudolph/subscriptions","organizations_url":"https://api.github.com/users/benrudolph/orgs","repos_url":"https://api.github.com/users/benrudolph/repos","events_url":"https://api.github.com/users/benrudolph/events{/privacy}","received_events_url":"https://api.github.com/users/benrudolph/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-05-29T19:46:10Z","updated_at":"2015-06-01T08:47:08Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dimagi/commcarehq-ansible/pulls/139","html_url":"https://github.com/dimagi/commcarehq-ansible/pull/139","diff_url":"https://github.com/dimagi/commcarehq-ansible/pull/139.diff","patch_url":"https://github.com/dimagi/commcarehq-ansible/pull/139.patch"},"body":"@czue @snopoke, given the server has postgres setup, this should make it pretty easy to setup `pgbench`. i'm in the process of running it now. the actual command is `pgbench9.1-*test`. While this takes a bit away from configurability, it will help with consistency and ensuring we can repeatably run the same tests on multiple machines. haven't tried setting up `9.4` yet but should be pretty straight forward. would be cool to be able to kick this off via fabric. if you do end up playing around with it make sure to override the email by using `-e \"receiver=someemail@abc.com\"` so that the results will be sent to you\r\n\r\nalso the 1 commit definitely doesn't do justice to the actual number of commits, but didn't want to pull a @TylerSheffels :wink: \r\n![screencapture-github-com-dimagi-commcarehq-ansible-pull-66-1428442004708](https://cloud.githubusercontent.com/assets/918514/7891277/7d572c44-0619-11e5-9650-83a9f0de0b74.png)\r\n"},"comment":{"url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/comments/107370315","html_url":"https://github.com/dimagi/commcarehq-ansible/pull/139#issuecomment-107370315","issue_url":"https://api.github.com/repos/dimagi/commcarehq-ansible/issues/139","id":107370315,"user":{"login":"snopoke","id":249606,"avatar_url":"https://avatars.githubusercontent.com/u/249606?v=3","gravatar_id":"","url":"https://api.github.com/users/snopoke","html_url":"https://github.com/snopoke","followers_url":"https://api.github.com/users/snopoke/followers","following_url":"https://api.github.com/users/snopoke/following{/other_user}","gists_url":"https://api.github.com/users/snopoke/gists{/gist_id}","starred_url":"https://api.github.com/users/snopoke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snopoke/subscriptions","organizations_url":"https://api.github.com/users/snopoke/orgs","repos_url":"https://api.github.com/users/snopoke/repos","events_url":"https://api.github.com/users/snopoke/events{/privacy}","received_events_url":"https://api.github.com/users/snopoke/received_events","type":"User","site_admin":false},"created_at":"2015-06-01T08:47:08Z","updated_at":"2015-06-01T08:47:08Z","body":"A little bit of reading shows that this benchmark has been marked as obsolete by the TCP: http://www.tpc.org/tpcb/default.asp\r\n\r\nHowever we can still use it as a starting point but we should definitely think about trying a more realistic test (perhaps using [BenchmarkSQL](http://sourceforge.net/projects/benchmarksql/) or [HammerDB](http://hammerora.sourceforge.net/index.html))"}}