Hello,
I migrated from phpBB to bbPress recently. My forum has ~1Million posts. My postmeta table is 30GB.
Is there anything I can do to shrink it?
I noticed there are many lines for every post like _bbp_old_xxxx, which i suspect comes from migration.
It’s safe to delete all those records with _old_ in it? Or anything else? 30GB seems quite too much even for that amount of posts, compared to the old phpbb db size…

[@matrixino Participant 6 years, 5 months ago]

Anyone?

[@indrekhirsnik Participant 6 years, 5 months ago]

Postmeta size should not be that big.

I have 2.6m+ posts and it is way smaller.

Can you make a query and list, how many distinct meta_keys you have in your DB.