Though I just love the new features of WordPress 2.7, one of its most nagging things is "Post Revisions". If you don’t know what Post Revisions is, well it is a wiki like tracking system for both Posts and Pages which might come in handy for multi author blogs.
It keeps every post revision in the wp-posts database. Sometime and some posts later, the database will keep on getting bigger and finally becomes a big bloated database.
Fortunately, there are ways to disable the Post revisions, if you don’t want it.
The Manual Way
1. Open your wp-config.php file which is usually in the wordpress home directory.
2. Now Add this line
and save the file.
Thats all, Now WordPress will not attempt to save any revisions, except the one AutoSave per post.
Well, if you don’t want to risk the manual way, you can try the Revision Control Plugin. This plugin give the complete control to the user whether he want to enable/ disable Post revisions. You can also limit the number of post revisions or even delete specific post revisions via this plugin.
Now, you might ask, what about the existing revisions? How to delete that?
Well, that is simple as well, All you need to do is run a simple SQL query on your database and you will be done.
At this point, I would recommend you to take a backup of your database, just in case, something goes wrong in the process.
Once Backup is done, Just open your phpMyAdmin or anything else you use for database access, and run this query
DELETE FROM wp_posts WHERE post_type="revision";
That is all. Now all the post revisions have been deleted and as well as the post revisions feature have been disabled.
When I did the above procedures, I reduced my database by 2.5 MB.
Impressive, Ain’t it?