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.

Update a Softaculous staging site with the latest live DB
What is softaculous staging? How do I make my staging site live? How do I make a softaculous staging site? How do I create a staging site in cPanel? W...
Is it good practice to use REST API in wp-admin plugin page? [closed]
Should I disable REST API? Should I disable WordPress REST API? Should I disable WP JSON? What is WordPress REST API used for? How do I block REST API...
How to get Regenerate Thumbnails plugin to make larger plugins than original? [closed]
How do I resize a thumbnail in WordPress? Which plugin is used to regenerate thumbnails? What does force regenerate thumbnails do? Why are my thumbnai...