why there are so many posts whoes post_type is revision? will these records waste too much database space?

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.

Related Posts:

  1. How do I batch create revisions of all posts?
  2. Manually removing revision post types
  3. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  4. Why my wp_posts data is so huge?
  5. Delete post revisions only for a single post
  6. Clean up customize_changeset in DB
  7. Where is the old post permalink slug stored?
  8. SQL Query for getting all posts in their latest revised state
  9. How to Group Posts by the First Letter or Number?
  10. How are terms connected with posts in database?
  11. Moving WordPress to new server: no posts found
  12. how to enable different number of revisions for different blogs when using WPMU?
  13. Setting post meta data to random value during post status transition / on publish
  14. How to change post status from publish to draft using hook in wordpress?
  15. Hiding by default specific post status on backend list?
  16. Custom Post Status Posts viewable to the public
  17. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  18. Insert posts in two tables
  19. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
  20. Adding a cancel button to edit post screen
  21. add filter to “quick edit menu” in wordpress admin
  22. Are posts updated or built from revisions + autosaves?
  23. How much of my site can I recover from public_html?
  24. What differences are there between a Privately Published post and a Draft post?
  25. Reset/Reorder posts ID in the MySQL wp_posts table
  26. Understand post type
  27. Update post status from “publish” to “trash” for half of posts
  28. Most recent post from another database
  29. What structure should post_content have in the database?
  30. How can I set a Post’s default visibility to private and pending review checked
  31. View the number of entries recorded per day
  32. Define a wordpress constant through plugin functions?
  33. Post revisions disappeared (for some posts)
  34. how to remove dash (-) post status from post title on posts listing page wordpress
  35. How to delete all the content of a wordpress site without deleting the Post and pages?
  36. Extracting post categories
  37. How to hide html tags on revision comparison pages?
  38. Admin – create custom post status and display above table
  39. Restrict edit, but allow preview for custom post status
  40. WordPress capabilities on pending post status
  41. Visual (non-HTML) display of post revisions [closed]
  42. When open add new post or page WordPress add post with ID=0 continuously [closed]
  43. wp_posts table: safely remove unused columns to save database storage
  44. Anyone know why wordpress converts some html entities to their numeric equivalents?
  45. Remove a shortcode from all WordPress posts
  46. how to get random post id by using post type
  47. Display post changelog in post
  48. Delete all drafts?
  49. $post->post_type not working
  50. Is it possible to use WP_Query to only pull posts with attachments?
  51. how can i allow users to view their own pending posts in a front-end page
  52. Get posts and include taxonomy term
  53. Post type no single page
  54. Add field to user meta table in database when link is clicked
  55. How safe is it to delete old posts edits to save database space?
  56. wp_posts table extremely large
  57. How to Assign / Move all Deleted post to a category
  58. Saving Post Data in Another Database
  59. Is there a way getting post fields using `transition_post_status`
  60. Restore woocommerce orders
  61. Post Status Frontend Announcement
  62. Display amount of pending posts in back/front end
  63. Import custom database into wp and keep the post id
  64. Showing posts for today and future
  65. why the posts queried from sql is more than those showed on the page?
  66. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  67. Is there a function to get post info for any publish_status by post ID?
  68. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  69. How Can I Always Display A Particular Post First Using WP_Query?
  70. Help on conditional statement to accompany wp_insert_post function please?
  71. How can I globally italicize list of texts in the UI database or Posts? [closed]
  72. Show Last Revision Of Post That Has A Published Status On Single Page
  73. Target only single product page
  74. Menu Items disappearing/being empty on save or post edit
  75. Updating post status via rest api
  76. Prevent a post with a specific ID from being created
  77. Bulk find & replace on WordPress posts/pages (minus image paths)
  78. How publish post from pending status
  79. Hide or remove custom post status
  80. Put page on Archived statut after end of publication date
  81. get_next_post() not working with future post status
  82. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  83. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  84. how i show manual data in a post
  85. Maximum number of posts per page before affecting performance?
  86. SQL trigger failes with post_content
  87. Surrogate ID for posts, is there an alternative field in the posts table?
  88. get backup file from wordpress database in x days
  89. Expired Post with More Recent Time Stamp?
  90. Converting Posts to Pages
  91. How to change the publishing date of each posts?
  92. Extra field in wp_post instead of postmeta
  93. Given two custom post types: Automatically add meta fields from one custom post type to another
  94. Load posts from external source if not found in database
  95. Taxonomy Category category.php not working
  96. How do i retrive a post from a custom post type
  97. Do anything on post_status change [duplicate]
  98. What effect can a large wp_post table have on overall site performance?
  99. How can I merge a several related posts into one post?
  100. Restore posts, but only posts that exist in my database backup