I've trying to cut down on the time to query a custom post type. After looking at the database and the wp_postmeta table, for some reason, there is some duplicate meta values for the same post_id and meta_key. The only difference is the meta_id.

Nacin talks about this here http://wordpress-hackers.1065353.n5.nabble.com/How-to-get-the-meta-ID-td572.html

Some of these duplicates are pretty large. I bet if I were to get rid of them, I would cut the size of the wp_postmeta table down to 1/3 of the size which hopefully will make my query faster.

Anyone have any suggestions on how to get rid of duplicates and why they may exists? It's only happening on a some specific meta data.


1 Answer 1


After investigating, I realized that it was left over from some fields that I no longer used so I was able to get rid of them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.