{"action":"created","issue":{"url":"https://api.github.com/repos/pypa/warehouse/issues/3045","repository_url":"https://api.github.com/repos/pypa/warehouse","labels_url":"https://api.github.com/repos/pypa/warehouse/issues/3045/labels{/name}","comments_url":"https://api.github.com/repos/pypa/warehouse/issues/3045/comments","events_url":"https://api.github.com/repos/pypa/warehouse/issues/3045/events","html_url":"https://github.com/pypa/warehouse/pull/3045","id":299820220,"number":3045,"title":"Defer the Release.description column","user":{"login":"dstufft","id":145979,"avatar_url":"https://avatars3.githubusercontent.com/u/145979?v=4","gravatar_id":"","url":"https://api.github.com/users/dstufft","html_url":"https://github.com/dstufft","followers_url":"https://api.github.com/users/dstufft/followers","following_url":"https://api.github.com/users/dstufft/following{/other_user}","gists_url":"https://api.github.com/users/dstufft/gists{/gist_id}","starred_url":"https://api.github.com/users/dstufft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dstufft/subscriptions","organizations_url":"https://api.github.com/users/dstufft/orgs","repos_url":"https://api.github.com/users/dstufft/repos","events_url":"https://api.github.com/users/dstufft/events{/privacy}","received_events_url":"https://api.github.com/users/dstufft/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-23T19:15:45Z","updated_at":"2018-02-23T19:26:23Z","closed_at":null,"author_association":"OWNER","pull_request":{"url":"https://api.github.com/repos/pypa/warehouse/pulls/3045","html_url":"https://github.com/pypa/warehouse/pull/3045","diff_url":"https://github.com/pypa/warehouse/pull/3045.diff","patch_url":"https://github.com/pypa/warehouse/pull/3045.patch"},"body":"The vast bulk of the time, when querying against a Release we do not want the description column, because the column is very large and can easily spike memory and make queries take longer, particularly when loading multiple Releases.\r\n\r\nInstead we will defer the column so that fetching it requires making another query or explicitly un-defering it. This will cause an extra query to happen on views that do not have direct control over the query (e.g. ones using the Pyramid Context objects) but the impact of a single extra query on these pages is pretty low while the impact of loading this column by default is playing a whack-a-mole game with any query against Release to add a load_only() or defer() option."},"comment":{"url":"https://api.github.com/repos/pypa/warehouse/issues/comments/368113886","html_url":"https://github.com/pypa/warehouse/pull/3045#issuecomment-368113886","issue_url":"https://api.github.com/repos/pypa/warehouse/issues/3045","id":368113886,"user":{"login":"dstufft","id":145979,"avatar_url":"https://avatars3.githubusercontent.com/u/145979?v=4","gravatar_id":"","url":"https://api.github.com/users/dstufft","html_url":"https://github.com/dstufft","followers_url":"https://api.github.com/users/dstufft/followers","following_url":"https://api.github.com/users/dstufft/following{/other_user}","gists_url":"https://api.github.com/users/dstufft/gists{/gist_id}","starred_url":"https://api.github.com/users/dstufft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dstufft/subscriptions","organizations_url":"https://api.github.com/users/dstufft/orgs","repos_url":"https://api.github.com/users/dstufft/repos","events_url":"https://api.github.com/users/dstufft/events{/privacy}","received_events_url":"https://api.github.com/users/dstufft/received_events","type":"User","site_admin":false},"created_at":"2018-02-23T19:26:23Z","updated_at":"2018-02-23T19:26:23Z","author_association":"OWNER","body":"I'll create a second PR for the ``load_only()`` calls, wanted to keep them separate because some of the ``load_only()`` calls may still make sense."}}
{"actor":{"display_login":"dstufft"}}