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.

Wordpress Permalink Issue for media permalink leading to 404 page when set as postname
How do I fix a permalink issue in WordPress? How do I change the media Permalink in WordPress? How do I change permalinks in WordPress without breakin...
How to show specific category products on top while sorting by latest woocommerce?
How do I manage WooCommerce product sorting options? How do I show a category wise product in WooCommerce? How do I arrange categories in WooCommerce?...
How to cache a custom API call?
Can API calls be cached? How do I cache API? How do you cache API calls in react? How can I speed up API calls? What is caching in REST API? Are JSON ...