Is it wise to delete post revisions and autosaves from database?

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.

Related Posts:

  1. Safest way to bulk delete post revisions
  2. Exporting revisions
  3. How would I see which wordpress posts have a revision history without opening each one?
  4. How to edit posts/pages without making the change live?
  5. How to Determine a Post’s Last Edited Date?
  6. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  7. Oracle SQL query for Date format
  8. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  9. Can I have multiple primary keys in a single table?
  10. Using wpdb to connect to a separate database
  11. Database connection close
  12. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  13. How to create bulk page and content? [closed]
  14. Importing posts from old website to new conflicting post ID’s?
  15. WP_Options ID high
  16. The revisions table in my database is at 70% capacity and growing. What should I do?
  17. WordPress for a very large website
  18. How to use multiple database in wordpress?
  19. What is the fastest way to generate a unique id number when registering a user
  20. How best to inject ads between posts in the loop?
  21. Cloning and syncing a WordPress website
  22. Does thumbnail regeneration edit the database?
  23. Using table lock with wp_insert_post?
  24. Should I remove transients from the wp_options table?
  25. WordPress doesn’t show all posts in database
  26. Show last modified date of database
  27. Extracting the post_id via the wp_insert_post action (external db query)
  28. Are custom tables in the database overwritten when WordPress is updated to new versions?
  29. What is the proper way to validate and sanitize JSON response from REST API?
  30. What generates these very slow postmeta queries? [closed]
  31. How to migrate a website based on a custom database to wordpress?
  32. How do I get the posts within a certain year/date(with sql query)?
  33. batch UPDATE autoload value in wp_options table
  34. Displaying BLOB PDF File
  35. How to fix the disappearance of the “\” character when updating a post in the database
  36. Data storage for JS app using WP REST API
  37. How to scan barcode and store data into a database [closed]
  38. Fetching values from database for select box
  39. WP CLI Core install – blank database
  40. Update from 4.5 to 4.6 failing
  41. Setup 3 Sites To Connect To 1 Database and Share Data
  42. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  43. fastest replacement DB
  44. Does auto_load to ‘no’ in wp_options improve performance
  45. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  46. Have working sql query… trying to adjust it to use $wpdb
  47. Best host for running large mem and processor intensive WordPress sites?
  48. Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
  49. In which format the data is stored in WordPress Databases?
  50. Strange characters added to the database
  51. Is it possible to rebuild the website while not accesseing the original database?
  52. Error message on blog posts only on my local environment [closed]
  53. how to read database fields
  54. $wpdb->query can’t insert data
  55. Can you refresh ONLY the wordpress adminbar and not the whole page?
  56. After database migration, theme mods don’t show [closed]
  57. Remote database connection and local development
  58. How can I detect right db type?
  59. Add search bar to Custom Database Table in WordPress Dashboard
  60. Design problems when exporting remote database for local development
  61. Website displays old version of page
  62. Image link issues after importing a database backup to my local web server
  63. multiple wordpress installs w/shared user database but separate content databases
  64. A change in URL slug in database returns 404, how can I do auto-redirect?
  65. Updating seperate database when post attachment is changed
  66. add featured image dialog box disappear
  67. Displaying table data on a page
  68. muliple wordpress installs (network) on different databases
  69. White Screen in Home Page
  70. Continuous SQL query errors from outside source
  71. Whats the best practise on how to store json data from a custom settings page?
  72. Recovery – Restore Database after moving folder location locally
  73. Migrate Users From laravel to wordpress
  74. /wp-admin not accessible after migrating to local host (no plugin issue)
  75. Job and Employee Performance Tracking with Product Safety
  76. how add more field to wp user and save it to database
  77. set_transient fails if the value has more than 60.000 characters
  78. How do I cleanup my database with data that is no longer being used?
  79. Malware in old website – how to migrate?
  80. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  81. How to optimize wp_option table?
  82. About wp database hooks (error establishing connection)
  83. Clean up customize_changeset in DB
  84. How to display $wpdb->insert_id; value on redirected page
  85. Database for JQuery Autocomplete field
  86. Should I Use only wpdb Class to Write Custom Queries?
  87. Create Tables in WordPress
  88. Catchable fatal error in formatting.php
  89. Wrong url for the images while using same database for two WordPress installations
  90. WordPress Failed to Login (DB Error)
  91. Sending WordPress database information to cross domain the safe way?
  92. Database Name Change
  93. Share WordPress Database
  94. Where To Find bb_profile_data(); In bbPress?
  95. ERROR: “Table Prefix” must not be empty
  96. How do you build a database-centric site in WP?
  97. Attach posts based on category and position
  98. wp_usermeta key problem
  99. Database Queries are crashing the server
  100. Uploading to WordPress Database

Leave a Comment