{"action":"created","issue":{"url":"https://api.github.com/repos/convox/rack/issues/386","repository_url":"https://api.github.com/repos/convox/rack","labels_url":"https://api.github.com/repos/convox/rack/issues/386/labels{/name}","comments_url":"https://api.github.com/repos/convox/rack/issues/386/comments","events_url":"https://api.github.com/repos/convox/rack/issues/386/events","html_url":"https://github.com/convox/rack/issues/386","id":136399699,"number":386,"title":"Better default parameters for Postgres","user":{"login":"ddollar","id":3308,"avatar_url":"https://avatars.githubusercontent.com/u/3308?v=3","gravatar_id":"","url":"https://api.github.com/users/ddollar","html_url":"https://github.com/ddollar","followers_url":"https://api.github.com/users/ddollar/followers","following_url":"https://api.github.com/users/ddollar/following{/other_user}","gists_url":"https://api.github.com/users/ddollar/gists{/gist_id}","starred_url":"https://api.github.com/users/ddollar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddollar/subscriptions","organizations_url":"https://api.github.com/users/ddollar/orgs","repos_url":"https://api.github.com/users/ddollar/repos","events_url":"https://api.github.com/users/ddollar/events{/privacy}","received_events_url":"https://api.github.com/users/ddollar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/convox/rack/milestones/4","html_url":"https://github.com/convox/rack/milestones/Services","labels_url":"https://api.github.com/repos/convox/rack/milestones/4/labels","id":1603618,"number":4,"title":"Services","description":"Solidify the `convox services` namespace. Goals:\r\n\r\n- [ ] Make service creation and updates crisp\r\n- [ ] Add more services","creator":{"login":"nzoschke","id":147410,"avatar_url":"https://avatars.githubusercontent.com/u/147410?v=3","gravatar_id":"","url":"https://api.github.com/users/nzoschke","html_url":"https://github.com/nzoschke","followers_url":"https://api.github.com/users/nzoschke/followers","following_url":"https://api.github.com/users/nzoschke/following{/other_user}","gists_url":"https://api.github.com/users/nzoschke/gists{/gist_id}","starred_url":"https://api.github.com/users/nzoschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nzoschke/subscriptions","organizations_url":"https://api.github.com/users/nzoschke/orgs","repos_url":"https://api.github.com/users/nzoschke/repos","events_url":"https://api.github.com/users/nzoschke/events{/privacy}","received_events_url":"https://api.github.com/users/nzoschke/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":2,"state":"open","created_at":"2016-02-24T19:05:35Z","updated_at":"2016-03-05T00:44:24Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2016-02-25T14:20:57Z","updated_at":"2016-03-05T01:20:14Z","closed_at":null,"body":"From @idyll\r\n\r\n> You need to:\r\n> \r\n> 1. make a new parameter group based on the same type as the old one in RDS\r\n> 2. change the DB instance to use the new parameter group\r\n> 3. reboot the server.\r\n> \r\n> to check the changes have been applied open a console and run `show max_connections;`\r\n> \r\n> It looks like AWS reduced the numbers by 60% with the latest PG release.\r\n\r\n```\r\nmax_connections\r\n{DBInstanceClassMemory/20000000}\r\n```\r\n\r\nNeed to make the `postgres` service template create a parameter group and use it."},"comment":{"url":"https://api.github.com/repos/convox/rack/issues/comments/192543151","html_url":"https://github.com/convox/rack/issues/386#issuecomment-192543151","issue_url":"https://api.github.com/repos/convox/rack/issues/386","id":192543151,"user":{"login":"nzoschke","id":147410,"avatar_url":"https://avatars.githubusercontent.com/u/147410?v=3","gravatar_id":"","url":"https://api.github.com/users/nzoschke","html_url":"https://github.com/nzoschke","followers_url":"https://api.github.com/users/nzoschke/followers","following_url":"https://api.github.com/users/nzoschke/following{/other_user}","gists_url":"https://api.github.com/users/nzoschke/gists{/gist_id}","starred_url":"https://api.github.com/users/nzoschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nzoschke/subscriptions","organizations_url":"https://api.github.com/users/nzoschke/orgs","repos_url":"https://api.github.com/users/nzoschke/repos","events_url":"https://api.github.com/users/nzoschke/events{/privacy}","received_events_url":"https://api.github.com/users/nzoschke/received_events","type":"User","site_admin":false},"created_at":"2016-03-05T01:20:14Z","updated_at":"2016-03-05T01:20:14Z","body":"@idyll, so I can imagine a MaxConnections Parameter on a postgres stack now.\r\n\r\nShould the value be the whole `{DBInstanceClassMemory/15000000}` string? Passing options through transparent is always nice and easy.\r\n\r\nI can also imagine trying to make MaxConnections an integer and calculating the right denominator, but we'd need to maintain a map of DBInstanceClassMemory values..."}}