Support » Plugin: Optimize Database after Deleting Revisions » Post Meta Orphan Question

  • Resolved Shawn33

    (@shawn33)


    Hi, I was previously using “Revision Control” but just switched to this instead.

    I don’t know much about how WP databases work, so I apologize if this is a dumb question…

    I saw that someone in the support forum for that plugin said it was only deleting data from the wp_posts table and leaving everything in the wp_postmeta table.

    I noticed my wp_postmeta table has over 2,700 rows and I only around 40 posts, so I figured I had the same problem and decided to try this plugin instead.

    When I ran this plugin I expected it would get rid of most of those rows but it only deleted around 9 or so.

    Does that mean all those other rows are necessary, or is this plugin just not catching the useless ones for some reason?

    Thanks,

    Shawn

    http://wordpress.org/extend/plugins/rvg-optimize-database/

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

    (@cageehv)

    Hey Shawn,

    Deleting ‘Post Meta Orphans’ means:
    All rows in the wp_postmeta table which don’t have a corresponding row in the wp_posts table will be deleted.

    So, it looks like all these 2700 rows are related to one of these +/- 40 posts. Is that correct?

    Peace,
    Rolf

    Hey Rolf, thanks for the reply and the insight. It does look like all the wp_postmeta rows have a post id that corresponds to a post id also found in wp_posts. So I guess everything looks good then.

    I think what confused me is that I only have 40 posts but the wp_posts table actually has over 400 rows. I didn’t realize all my media uploads are also contained there as well.

    Thanks again for the help,

    Shawn

    Plugin Author cageehv

    (@cageehv)

    Hey Shawn,

    Glad I could help!

    Peace,
    Rolf

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Post Meta Orphan Question’ is closed to new replies.