[ad_1]
I have a database with 8GB on wp\_posts and 10GB on wp\_postmeta, its running on a mySQL, what can i do for improve the performance?
Maybe change for postgres, is that a good option?
Its not the revisions.
You can install a plugin called LiteSpeed Cache. They have a tool that cleans up the database!
How many posts do you have? Those are some pretty big tables, but if you genuinely have hundreds of thousands of posts then you may not be able to shrink them much, and would better off looking at some server-side caching to speed things up.
On the other hand, if you don’t have enormous numbers of massive posts, there is probably a load of corrupt or trash data in those tables – if that’s the case, try repairing/optimising them in PHPmyAdmin or cPanel etc first, or try a database optimisation plugin.
Make sure you take full back-ups before doing this, and with a DB of that size you should probably do a trial ‘restore’ just to make sure you can do it, as it’s probably too big to directly upload via PHPmyAdmin and may need to be done on the command line, or perhaps via bigdump.php.
>8GB on wp_posts and 10GB on wp_postmeta
What is the content of these tables?
The entire wordpress.org support forum has 8 gig in posts, and 18 gig in postmeta. That’s literally more than 10 million posts. So the question you have to answer is, why is your database so big?