Post Revisions tracking system was introduced on the WordPress version 2.6. With this, everytime you save your post or the WordPress system automatically saved your post, it also creates a new data in your wp-posts table in the database. But this data has the type called “revision”.
The very purpose of this is for you to be able to get the previous copy of your revision if ever you did something wrong with the latest revision of your post.
But the negative effect of this is that your database is getting bigger especially if you saved your post several times before posting it, or if you are editing your posts several times. And as you already know, bigger database file will just be a burden of your server, thus slowing your site, if not crashing it off.
Turn Off Post Revisions
You can however turn off the Post Revisions Tracking System. That is if you think you don’t need this kind of feature. Just follow the steps below:
Step 1: Log-in to your cPanel.
Step 2: Find the wp-config.php file. It is usually found in the WordPress directory.
Step 3: Edit the wo-config.php file and insert this: define(‘WP_POST_REVISIONS’, false);
Step 4: Save the file.
So, now the feature has been turned off already.
Delete Post Revisions from the Database
Now, if this feature has been turned on for a long time already, then I am sure that there are lots of post revisions entries in your database especially if you are posting a lot into your wordpress blog or site. You might need to delete them.
You can delete those entries by running the Sql command: DELETE FROM wp_posts WHERE post_type = “revision”;
You can run that code using the MyPhPAdmin of your cPanel. If you are using the WP-DBManager WordPress plugin, then you can make use of its Run SQL feature.