Title: wp_postmeta table size
Last modified: August 18, 2016

---

# wp_postmeta table size

 *  Resolved [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/)
 * The wp_postmeta curretnly using 14.2MB in the DB. Size wise this is the biggest
   table. I’m wondering if there is anything i can to so reduce the size of it.
 * Information found on [http://codex.wordpress.org/Database_Description](http://codex.wordpress.org/Database_Description)
   doesn’t help. Neither optimizing the DB via phpmyadmin.
 * tia

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

 *  [Les Bessant](https://wordpress.org/support/users/lesbessant/)
 * (@lesbessant)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451841)
 * Do you have any plugins that write data in there? There was a release of Ultimate
   Tag Warrior that had a bug that caused it to flood that table.
 *  Thread Starter [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451843)
 * I’m always using the latest Ultimate Tag Warrior when it’s out. Currently i’m
   running on 3.14 .
 * Other than that, i’m using Google Sitemaps, Simple Recent Comments, Feedburner
   Feed Replacement, Head META Description, Code Markup and Akismet.
 * How do i know which one might causing the issue, if any issue?
 * Do you agree that 14.2MB for a table is way too much?
 * tia
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451844)
 * Regarding the UTW thing, see these two list posts from wp-hackers:
 * [http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007762.html](http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007762.html)
   
   [http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007763.html](http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007763.html)
 * Apparently some manual cleanup had to happen.
 *  Thread Starter [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451847)
 * That might makes sense since i was running the same UTW version. I’ve now updated
   to 3.1415. I’ll check my table. Thank you.
 *  Thread Starter [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451849)
 * It seems i was hit by that bug. Need to figure out how to delete those hundreds
   if not thousands of extra UTW lines.
 *  Thread Starter [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451850)
 * The solution is:
 * – Backup your site and your database
    – Update to the latest UTW version, currently
   3.1415 – Manage > Tag > Tidy Tags
 * more info can be found here:
    [http://www.neato.co.nz/archives/2006/08/10/ultimate-tag-warrior-3141/](http://www.neato.co.nz/archives/2006/08/10/ultimate-tag-warrior-3141/)
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451851)
 * Glad to hear you got it sorted out.
 * Mark this one as “Resolved” up top?
 *  Thread Starter [titanas](https://wordpress.org/support/users/titanas/)
 * (@titanas)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451981)
 * I missed that. Thanks HandySolo 🙂

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

The topic ‘wp_postmeta table size’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [db](https://wordpress.org/support/topic-tag/db/)
 * [UTW](https://wordpress.org/support/topic-tag/utw/)
 * [wp_postmeta](https://wordpress.org/support/topic-tag/wp_postmeta/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 3 participants
 * Last reply from: [titanas](https://wordpress.org/support/users/titanas/)
 * Last activity: [19 years, 8 months ago](https://wordpress.org/support/topic/wp_postmeta-table-size/#post-451981)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics