Purge revision table

[Isabel M Ruiz Mellado]

Hi all,

ckan version: 2.8

My revision table has 35.000.000 rows.

I monitored ckan database and this select 

SELECT count(*) AS count_1
FROM revision
WHERE revision.author = 'adminckan'

is executed manytimes per second and spend a lot of time.

Is there anyway to purge it revision table ?

[william dutton]

Please see

https://github.com/ckan/ckan/wiki/Migrate-package-activity

and

https://github.com/ckan/ckan/blob/master/CHANGELOG.rst#v290-2020-08-05

That table I do believe is dropped in favour of a new way of storing revisions in the activity table that uses the plugin ckanext-activity (ckan core turned plugin still in core repo)

This data is also used for dashboard, email of recent activity, package activity, dataset activity. In later versions of ckan you can turn this off and no history will be created.