Large wp_postmeta

  • Resolved ggenglish

    (@ggenglish)


    7 years, 2 months ago

    Using elementor 1.1.6 – 1.2.0

    I have a single page that had an abnormally large wp_postmeta size (20M+ for only one page). At first I thought it might have been the new revisions so I ran an optimizer plugin which deleted a few rows but was still too large. I then went and looked and found tons of orphan wp_postmeta.post_ids with no existing wp_post.id. As a test I deleted all of these orphans and it did not seem to affect the page. After deleting wp_postmeta is now 300k.

    Can you think of what I did wrong and is it ok what I did to resolve?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Yakir Sitbon

    (@kingyes)

    7 years, 2 months ago

    You can limit your revision by this doc:

    https://codex.wordpress.org/Revisions

    BTW, we are working to improve the data we save on the DB. But right now you need to limit the number revision on your website.

    Thread Starter ggenglish

    (@ggenglish)

    7 years, 2 months ago

    Thanks for the reply.

    btw, just in case anyone comes across this thread with similar interest i realize now that when i used wp-optimizer plugin to remove the revisions it created the orphan threads in wp_postmeta as result. so instead of deleting them manually you can just use the plugin to do it.

    Plugin Author Yakir Sitbon

    (@kingyes)

    7 years ago

    BTW – In the last version of Elementor, we reduced the data from wp_postmeta by 80% off..

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Large wp_postmeta’ is closed to new replies.