Title: Huge postmeta table
Last modified: October 1, 2017

---

# Huge postmeta table

 *  [viche](https://wordpress.org/support/users/viche/)
 * (@viche)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/huge-postmeta-table/)
 * Hi!
 * Any Idea why postmeta table is huge (and what to do about it)? It is over 100mb.
 * Except some static pages the only content is the products.
 * Please advice.
 * Thanks in advance.
 * Best regards, Niclas
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fhuge-postmeta-table%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Peter Lawrenson](https://wordpress.org/support/users/lorro/)
 * (@lorro)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/huge-postmeta-table/#post-9546544)
 * Did you try:
    Dashboard > WooCommerce > Status > Tools tab, then click the two
   delete transients buttons and the delete orphaned variations button.
 * Also, try this database utility: (always been good for me but back-up before 
   using)
    [https://wordpress.org/plugins/wp-optimize/](https://wordpress.org/plugins/wp-optimize/)
 *  Thread Starter [viche](https://wordpress.org/support/users/viche/)
 * (@viche)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/huge-postmeta-table/#post-9546682)
 * Thanks [@lorro](https://wordpress.org/support/users/lorro/)
 * Your first idea only removed a couple of thousand. Still 1 338 055 records (116,7
   MB) according to wp optimize after I run it..
 * Do I have to do some extra settings/choices?
 * Thanks!
 * //niclas
 * Optimization Notes
    Optimize database tables Tables using the InnoDB engine (
   46) will not be optimized. Other tables will be optimized (0). Run optimization
   Clean all post revisions No post revisions found Run optimization Clean all auto-
   drafts and trashed posts No auto draft posts found No trashed posts found Run
   optimization Remove spam and trashed comments No spam comments found No trashed
   comments found Run optimization Remove unapproved comments No unapproved comments
   found Run optimization Remove expired transient options 4 expired transient in
   your database Run optimization Remove pingbacks No pingbacks found Run optimization
   Remove trackbacks No trackbacks found Run optimization Clean post meta data 98
   orphaned postmeta in your database Run optimization Clean comment meta data No
   orphaned comment meta data in your database Run optimization Clean orphaned relationship
   data No orphaned relationship data in your database
 *  Thread Starter [viche](https://wordpress.org/support/users/viche/)
 * (@viche)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/huge-postmeta-table/#post-9546735)
 * I’m using Advanced woo search for search and after I reindexed the record is 
   now 1 624 382.
 * Is it safe to drop the table? 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Huge postmeta table’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [viche](https://wordpress.org/support/users/viche/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/huge-postmeta-table/#post-9546735)
 * Status: not resolved