How do I clean up the wp_postmeta table and wp_posts table

  • Resolved AlGala

    (@algala)


    3 days, 14 hours ago

    Hi,

    (I accidently posted this on the updraft plus plugin forum)

    I see posts where people are saying that they have used WP-Optimize to clean up the wp_postmeta and wp_posts database table. How exactly does this work? I have been searching around and cannot figure out how to use WP-Optimize to reduce the size of the wp_postmeta table.

    I am currently working on a website (made with Elementor) whose wp_postmeta table is currently 893.05 MB and the wp_posts table is 354.44 MB. Not getting into the fact that Elementor somehow creates massive bloat in these tables – how can we reduce the size of these tables before we are penalized by our hosting company?

    I see an option to Clean post meta data, but under that is this message: No orphaned post meta data in your database. Does that mean that optimizing that will do nothing? If there are no orphaned post metadata, then will the optimization even do anything?

    Please let me know as soon as possible. Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support vupdraft

    (@vupdraft)

    The Premium version of the plugin does have the option to clean the post and post meta table indvidually.

    Orphaned post meta data – this is just post meta data that does not belong to any post. Optimising your tables could still provide vast improvements to these tables. Some plugins add a lot of bloat and the WPO can help reduce this.

    Thread Starter AlGala

    (@algala)

    Okay great, thanks for letting me know!

    Plugin Support vupdraft

    (@vupdraft)

    No problem, just let us know if you have any further questions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.