Remove Post & Page Revisions from Database
A few years ago WordPress introduced ‘Revisions’ so that one could restore a previous version of a Page or Post. Revisions can be a life saver should you want to revert to an older version if content has been deleted by mistake.
The problem with Revisions however is that they take up database space. If you’re an occasional blogger then this probably won’t have a major impact on database performance however if you have alot of content on your WordPress Site then it is advisable to occasionally remove the Revisions from the database (remember that Website performance is now a ranking factor for Google i.e. it is good WordPress SEO to keep your Site as fast as possible).
To remove old Revisions:
- Login to your Host PHPmyAdmin or your database manager
- Execute the following MySQL query:
DELETE FROM wp_posts WHERE post_type = "revision";
