{"action":"opened","issue":{"url":"https://api.github.com/repos/smartemission/smartemission/issues/124","repository_url":"https://api.github.com/repos/smartemission/smartemission","labels_url":"https://api.github.com/repos/smartemission/smartemission/issues/124/labels{/name}","comments_url":"https://api.github.com/repos/smartemission/smartemission/issues/124/comments","events_url":"https://api.github.com/repos/smartemission/smartemission/issues/124/events","html_url":"https://github.com/smartemission/smartemission/issues/124","id":329771874,"node_id":"MDU6SXNzdWUzMjk3NzE4NzQ=","number":124,"title":"Solve performance issues Postgres in Kubernetes","user":{"login":"justb4","id":582630,"node_id":"MDQ6VXNlcjU4MjYzMA==","avatar_url":"https://avatars2.githubusercontent.com/u/582630?v=4","gravatar_id":"","url":"https://api.github.com/users/justb4","html_url":"https://github.com/justb4","followers_url":"https://api.github.com/users/justb4/followers","following_url":"https://api.github.com/users/justb4/following{/other_user}","gists_url":"https://api.github.com/users/justb4/gists{/gist_id}","starred_url":"https://api.github.com/users/justb4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justb4/subscriptions","organizations_url":"https://api.github.com/users/justb4/orgs","repos_url":"https://api.github.com/users/justb4/repos","events_url":"https://api.github.com/users/justb4/events{/privacy}","received_events_url":"https://api.github.com/users/justb4/received_events","type":"User","site_admin":false},"labels":[{"id":337600346,"node_id":"MDU6TGFiZWwzMzc2MDAzNDY=","url":"https://api.github.com/repos/smartemission/smartemission/labels/Data/ETL","name":"Data/ETL","color":"0052cc","default":false},{"id":890837954,"node_id":"MDU6TGFiZWw4OTA4Mzc5NTQ=","url":"https://api.github.com/repos/smartemission/smartemission/labels/PDOK%20Migration","name":"PDOK Migration","color":"77c930","default":false}],"state":"open","locked":false,"assignee":{"login":"gerdos82","id":37865635,"node_id":"MDQ6VXNlcjM3ODY1NjM1","avatar_url":"https://avatars1.githubusercontent.com/u/37865635?v=4","gravatar_id":"","url":"https://api.github.com/users/gerdos82","html_url":"https://github.com/gerdos82","followers_url":"https://api.github.com/users/gerdos82/followers","following_url":"https://api.github.com/users/gerdos82/following{/other_user}","gists_url":"https://api.github.com/users/gerdos82/gists{/gist_id}","starred_url":"https://api.github.com/users/gerdos82/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gerdos82/subscriptions","organizations_url":"https://api.github.com/users/gerdos82/orgs","repos_url":"https://api.github.com/users/gerdos82/repos","events_url":"https://api.github.com/users/gerdos82/events{/privacy}","received_events_url":"https://api.github.com/users/gerdos82/received_events","type":"User","site_admin":false},"assignees":[{"login":"gerdos82","id":37865635,"node_id":"MDQ6VXNlcjM3ODY1NjM1","avatar_url":"https://avatars1.githubusercontent.com/u/37865635?v=4","gravatar_id":"","url":"https://api.github.com/users/gerdos82","html_url":"https://github.com/gerdos82","followers_url":"https://api.github.com/users/gerdos82/followers","following_url":"https://api.github.com/users/gerdos82/following{/other_user}","gists_url":"https://api.github.com/users/gerdos82/gists{/gist_id}","starred_url":"https://api.github.com/users/gerdos82/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gerdos82/subscriptions","organizations_url":"https://api.github.com/users/gerdos82/orgs","repos_url":"https://api.github.com/users/gerdos82/repos","events_url":"https://api.github.com/users/gerdos82/events{/privacy}","received_events_url":"https://api.github.com/users/gerdos82/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-06-06T08:47:48Z","updated_at":"2018-06-06T08:47:48Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"The current PostgreSQL instance in K8s is not deployed as a Docker Container by the SE Project \"hired\" as a general cloud service from Azure.  This has advantages in terms of maintenance: backups, upgrades, restores, cloning, and further are provided as part of this service. \r\n\r\nThe main problem now though is that the performance of the \"Azure PG\" is lagging behind the current (Docker PG) deployment. One issue, large connection setup time, was tackled by placing a Docker-based \"Connection-Pooler\" between the PG client and the PG DB.\r\n\r\nBut also in regular, simple queries a performance difference of a factor 10 was observed: the Azure PG being about a factor 8-10 slower. This issue is dedicated to attempt to fix the operational CRUD performance of Azure PG.\r\n\r\nFor one thing it was suspected that this had to do with \"locality\": the Azure PG instance may be within another Data Center or even within another country. This is step 1 to investigate. \r\n\r\nIn the ultimate case we may decide that PDOK SE will do its own PG Docker deployment, as in the current production env...But then again will put more maintenance burden on PDOK SE (maintaining backups ourselves, PG upgrades etc).\r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"justb4"}}