{"action":"created","issue":{"url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/18","repository_url":"https://api.github.com/repos/starkandwayne/habitat-plans","labels_url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/18/comments","events_url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/18/events","html_url":"https://github.com/starkandwayne/habitat-plans/issues/18","id":226919740,"number":18,"title":"Autotune postgresql.conf based on memory","user":{"login":"jamessewell","id":1216931,"avatar_url":"https://avatars0.githubusercontent.com/u/1216931?v=3","gravatar_id":"","url":"https://api.github.com/users/jamessewell","html_url":"https://github.com/jamessewell","followers_url":"https://api.github.com/users/jamessewell/followers","following_url":"https://api.github.com/users/jamessewell/following{/other_user}","gists_url":"https://api.github.com/users/jamessewell/gists{/gist_id}","starred_url":"https://api.github.com/users/jamessewell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamessewell/subscriptions","organizations_url":"https://api.github.com/users/jamessewell/orgs","repos_url":"https://api.github.com/users/jamessewell/repos","events_url":"https://api.github.com/users/jamessewell/events{/privacy}","received_events_url":"https://api.github.com/users/jamessewell/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-05-08T02:20:16Z","updated_at":"2017-05-16T08:33:08Z","closed_at":"2017-05-16T08:33:08Z","body":"It would be great if there was auto-tuning based on memory for at least the following:\r\n\r\n- effective_cache_size \r\n- shared_buffers \r\n- work_mem \r\n- maintenance_work_mem\r\n- temp_buffers \r\n\r\nI'd suggest saving these 'machine specific' settings at `$PGDATA/../pg_local` so each node in a cluster can have different settings - not sure how this would play with Habitat though?\r\n"},"comment":{"url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/comments/301713372","html_url":"https://github.com/starkandwayne/habitat-plans/issues/18#issuecomment-301713372","issue_url":"https://api.github.com/repos/starkandwayne/habitat-plans/issues/18","id":301713372,"user":{"login":"bodymindarts","id":8533296,"avatar_url":"https://avatars2.githubusercontent.com/u/8533296?v=3","gravatar_id":"","url":"https://api.github.com/users/bodymindarts","html_url":"https://github.com/bodymindarts","followers_url":"https://api.github.com/users/bodymindarts/followers","following_url":"https://api.github.com/users/bodymindarts/following{/other_user}","gists_url":"https://api.github.com/users/bodymindarts/gists{/gist_id}","starred_url":"https://api.github.com/users/bodymindarts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bodymindarts/subscriptions","organizations_url":"https://api.github.com/users/bodymindarts/orgs","repos_url":"https://api.github.com/users/bodymindarts/repos","events_url":"https://api.github.com/users/bodymindarts/events{/privacy}","received_events_url":"https://api.github.com/users/bodymindarts/received_events","type":"User","site_admin":false},"created_at":"2017-05-16T08:33:08Z","updated_at":"2017-05-16T08:33:08Z","body":"Resolved via https://github.com/starkandwayne/habitat-plans/commit/55353076535e35f396e2375ada2e7680673455f4"}}
{"actor":{"display_login":"bodymindarts"}}