wordpress 2.7 introduced me to post revisions — these are draft copies of your posts. these copies are saved in your wordpress database along with your posts, comments, etc. sometimes my revisions it gets to be ridiculously too many. apparently, the revisions are retained even after you have published the post thereby occupying unnecessary space in the database. so far, there is no built-in point-and-click method of getting rid of these revisions from the database.
i’ve found two ways to delete these revisions.
first, the hard way. fire up your phpadmin; choose your wordpress database; click on the sql icon and a window will pop up where you can enter and sql command:
DELETE FROM wp_posts WHERE post_type = "revision";
then click on ‘go’.
phpadmin will tell just just how many revisions were deleted. you’re done.
of course, there’s always the easy way. download and install a plugin called wp-optimize. this plugin can remove all post revisions plus optimize the database tables–the two functions that i usually use phpadmin for the maintenance of the sql tables (aka wordpress databases). other plugins have more database features but more is not necessarily better. its just more. this one’s right for my purpose.