Earlier we talked about WordPress post revision feature and how you can disable post revision with plugin or disable post revision with little hack. Though we have achieved the target to disable the post revision feature but still most important thing that remains there is deleting all previous version of WordPress post revision. If you have hundred+ posts you can see lots of post revision on your blog and obviously your wordpress database size will be big. To delete previous post revision you can run this query in your sql database to delete all instance of previous auto saved blog posts.
DELETE FROM wp_posts WHERE post_type = "revision";
Make sure you take the database backup before running this query. This will ensure the safety of your wordpress database. Alternatively you can use wp-optimize wordpress plugin, if you are not familiar with running sql query.
If i delete all the past revisions, will it help to increase the performance of my blog?
Is there a hook that can be included in the functions.php to prevent the revision writing?
Thanks!
Add
to wp-config.php
This is not the correct way of deleting revisions. Don’t do it this way.
Again came to this post when I just searched how many people are telling the same query to solve the problem. Finally I blogged about the correct method of doing it – http://blog.ashfame.com/2010/04/handling-wordpress-post-revisions-correctly/
No, it’ll just save u disk space ….
Yes
this would delete all the relations too … 
..
And also optimize your database..make it smaller in size..!!