Could

Can I split a huge wp_postmeta table across different databases or servers?

Can I split a huge wp_postmeta table across different databases or servers?

No. This is not practically possible primarily because there is no single interface to this table where you could implement the functionality you need, and even if you could, it would introduce some extremely gnarly problems.

Page How can I show subpages dropdown upon select on parent page to any page
How can I show subpages dropdown upon select on parent page to any page
How do I show a list of child pages in a parent page in WordPress? How do I show subpages in WordPress? How do parent pages work in WordPress? How do ...
Posts How to fetch all images from a WordPress draft using PHP?
How to fetch all images from a WordPress draft using PHP?
How do I get all images from WordPress? How do I get a list of all posts in WordPress? How do I fetch post data in WordPress? How do I show recent pos...
Slow Wordpress slow query
Wordpress slow query
WordPress can be prone to slower queries on the wp_posts table, if you have a large amount of data, and many different custom post types. If you are f...