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.

How to upload an image to a custom post type
How do I add multiple images to a custom post type? How do I upload a custom image in WordPress? How do I create a custom post type Gallery? How do I ...
Group Custom Taxonomies by Custom Field
How do I add custom fields to custom taxonomies? How do I get ACF taxonomy field? How do I add a custom field to custom taxonomy in WordPress? What ar...
Order is breaking wp_query
What is $WP_Query? What does WP_Query return? What is offset in WP_Query? What is Posts_per_page? What is Wp_reset_postdata ()? How do I write a query...