{"action":"created","issue":{"url":"https://api.github.com/repos/ahelsing/tickettest2/issues/1071","labels_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/1071/labels{/name}","comments_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/1071/comments","events_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/1071/events","html_url":"https://github.com/ahelsing/tickettest2/issues/1071","id":78011000,"number":1071,"title":"Archive expired entries associated with database tables, logging_entry and sa_slice.","user":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-19T09:27:38Z","updated_at":"2015-05-19T09:27:49Z","closed_at":null,"body":"Write some scripts that will move expired entries from database tables, logging_entry, logging_entry_attribute, sa_slice, and sa_slice_member so that searches are not bogged down by expired data.\n\n _Imported from trac ticket [#1071](http://trac.gpolab.bbn.com/proto-ch/ticket/1071),  created by rrhain on 06-13-2014 at 09:24, last modified: 08-04-2014 at 13:12_\n"},"comment":{"url":"https://api.github.com/repos/ahelsing/tickettest2/issues/comments/103414874","html_url":"https://github.com/ahelsing/tickettest2/issues/1071#issuecomment-103414874","issue_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/1071","id":103414874,"user":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"created_at":"2015-05-19T09:27:49Z","updated_at":"2015-05-19T09:27:49Z","body":"Created 2 scripts in proto-ch/bin that can be run to archive entries from logging_entry and sa_entry_table to reduce the size of the tables.   Also added the definitions of the new tables in schema.sql and wrote an update-1.sql shell to update the database.   But I think in the end, using pgbadger at http://dalibo.github.io/pgbadger/ helped identify indices that could be put in the table to speed up database access.  The scripts are there if they are deemed useful in the future.\n\n_Trac comment by rrhain on 08-04-2014 at 13:12_\n"}}