Do you have access to the physical server? Could be worth it to backup the db, temporarily remove data and diagnose if the obscene size is indeed causing the performance hit (then restore data back afterwards). That could take awhile though.
Or if you have access to the db, run some queries to see how long a simple select query from the posts table takes to run