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

I'm just wondering is it wise to delete all post revisions and autosaves from database every once in a while?
I mean they take a lot of database space and apparently have no use after the post has been published.

share|improve this question
No use is not absolutely true. When you search my answer, then there's one where we did something like liveediting Spreadsheets using the Post Revisions. Currently I'm also thinking about another implementation, where they get used to save edits-diffs like here on SE/SO using wp_text_diff(). – kaiser Oct 5 '12 at 8:06
Well in some rare cases what you said might be true, but in a usual Wordpress installation I don't think they're of much use. – Hamed Momeni Oct 5 '12 at 8:11
close voted as non constructive. – kaiser Oct 5 '12 at 8:20
Can I ask why? I have a question and it's not off-topic and it also is constructive for me. – Hamed Momeni Oct 5 '12 at 8:25
Two reasons: First, this site, it's questions & answers are not only for you, but for later readers also. Second, your answer will only summon opinions and not definitive answers. Your question title already asks "Is it wise(...)?". So the answers will be "in my opinion, I think, in that use case or this sceanrio", etc. That's what the blog will be for. – kaiser Oct 5 '12 at 9:44
up vote 3 down vote accepted

It all depends on your workflow. If you have no use for the post revisions and autosaves then disable them in wp-config and WordPress will clean them up on its own. You may also prefer to limit how many you keep at once.

Also the space they take up is unlikely to be of a great impact itself unless you're running on a tiny tiny server

Don't go deleting them manually through the database.

share|improve this answer

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.