WordPress introduced the Post Revisions feature from version 3.0. It comes handy if you’re running a multi-author blog. But for most WordPress blogs, it doesn’t add much value. Apart from this, the Post Revisions feature can seriously bloat your database with multiple copies of posts. If you are like me, making lots of changes before publishing a post and even after that, post revisions will end up being several times larger than the size of actual posts.
To turn the Post Revisions feature off, simply add the following code to your wp-settings.php file:
//Turn Off Post Revisions
define(‘WP_POST_REVISIONS’, false );
Before you turn off post revisions, don’t forget to delete the existing post revisions . Use the following SQL query through phpMyAdmin or similar applications. If you don’t have access to phpMyAdmin, install WP DB Manager plug-in. It has an option to “Run SQL Query”. Goes without saying, create a backup of the database and the entire blog before making such changes.
DELETE FROM wp_posts WHERE post_type = “revision”;