Purge revision table

Skip to first unread message

Isabel M Ruiz Mellado

Apr 19, 2024, 6:15:35 AMApr 19
to CKAN Development Discussions
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

Apr 19, 2024, 4:30:31 PMApr 19
to CKAN Development Discussions, Isabel M Ruiz Mellado
Please see

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.
Reply all
Reply to author
0 new messages