{"action":"closed","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4773","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4773/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4773/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4773/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/4773","id":103628471,"number":4773,"title":"Very high latencies while deleting many documents","user":{"login":"danielmewes","id":505365,"avatar_url":"https://avatars.githubusercontent.com/u/505365?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmewes","html_url":"https://github.com/danielmewes","followers_url":"https://api.github.com/users/danielmewes/followers","following_url":"https://api.github.com/users/danielmewes/following{/other_user}","gists_url":"https://api.github.com/users/danielmewes/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmewes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmewes/subscriptions","organizations_url":"https://api.github.com/users/danielmewes/orgs","repos_url":"https://api.github.com/users/danielmewes/repos","events_url":"https://api.github.com/users/danielmewes/events{/privacy}","received_events_url":"https://api.github.com/users/danielmewes/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/tp:performance","name":"tp:performance","color":"444444"}],"state":"closed","locked":false,"assignee":{"login":"danielmewes","id":505365,"avatar_url":"https://avatars.githubusercontent.com/u/505365?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmewes","html_url":"https://github.com/danielmewes","followers_url":"https://api.github.com/users/danielmewes/followers","following_url":"https://api.github.com/users/danielmewes/following{/other_user}","gists_url":"https://api.github.com/users/danielmewes/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmewes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmewes/subscriptions","organizations_url":"https://api.github.com/users/danielmewes/orgs","repos_url":"https://api.github.com/users/danielmewes/repos","events_url":"https://api.github.com/users/danielmewes/events{/privacy}","received_events_url":"https://api.github.com/users/danielmewes/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/104","html_url":"https://github.com/rethinkdb/rethinkdb/milestones/2.1.x","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/104/labels","id":1249551,"number":104,"title":"2.1.x","description":null,"creator":{"login":"danielmewes","id":505365,"avatar_url":"https://avatars.githubusercontent.com/u/505365?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmewes","html_url":"https://github.com/danielmewes","followers_url":"https://api.github.com/users/danielmewes/followers","following_url":"https://api.github.com/users/danielmewes/following{/other_user}","gists_url":"https://api.github.com/users/danielmewes/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmewes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmewes/subscriptions","organizations_url":"https://api.github.com/users/danielmewes/orgs","repos_url":"https://api.github.com/users/danielmewes/repos","events_url":"https://api.github.com/users/danielmewes/events{/privacy}","received_events_url":"https://api.github.com/users/danielmewes/received_events","type":"User","site_admin":false},"open_issues":31,"closed_issues":5,"state":"open","created_at":"2015-08-11T07:18:11Z","updated_at":"2015-08-28T23:10:38Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-08-28T01:41:33Z","updated_at":"2015-08-28T23:10:38Z","closed_at":"2015-08-28T23:10:38Z","body":"I think similar issues have been brought up before, but I just found a way to reproduce them easily:\r\n\r\nI started a server with a cache size of just 20 MB, and two large tables (a few million docs each).\r\nThe data was on an SSD.\r\nI then started running queries `r.table('table1').delete()` and `r.table('table2').delete()`.\r\n\r\nWhile the deletes were running, simple reads from those tables became extremely slow (often taking up to 15 seconds). Reads from a third table that I wasn't deleting from were still fast.\r\n\r\nWhat's even weirder though, is that access to many of the system tables also became extremely slow (multiple seconds for reading them). This included `table_config`, `table_status`, `jobs`, and even `stats`."}}