WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

from the following data we may know there are only 30 records which are meaningful, and there are 92 records of revision post_type which can not be shown on the blog.

so will these records waste too much database space?

is it recommended to save such kind of revisions? (btw, i may edit my blog oftenly)

mysql> select count(*),post_type, post_status from wp_137_posts group by post_type, post_status;
| count(*) | post_type | post_status |
|        1 | page      | publish     |
|        2 | post      | auto-draft  |     // also, should i delete this record?
|       30 | post      | publish     |
|       92 | revision  | inherit     |
4 rows in set (0.24 sec)
share|improve this question
up vote 3 down vote accepted

Every time you edit a post/page, WordPress creates timely revisions of it. Check the Firebug console for the requests that are sent at regular intervals when you are on the edit page. They are useful if you lose the post content at some point and want to get back to an earlier version of the post. Once you publish the final version of the post then you can delete all the post revisions.

And yes, they do take up your database space!

Solution: There's an excellent answer over here.

share|improve this answer
how to delete these revisions, since there maybe more than 20 revisions ... – hugemeow Sep 20 '12 at 20:00
20 is pretty less! There could be a lot more. Check this post by Lester Chan... lesterchan.net/wordpress/2008/07/17/… – Rutwick Gangurde Sep 21 '12 at 6:05
how to delete all the post revisions once i publish the final version? – hugemeow Nov 8 '12 at 11:44
Check my edit, I have added a link to an answer on WPSE. – Rutwick Gangurde Nov 9 '12 at 4:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.