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...
Secure WordPress API, how?
How to Secure the REST API Disable REST API — Disable REST completely for all non-logged users. REST API Toolbox — Disable only the REST users endpoin...
How to keep the capability of users and disable Gutenberg editor in WordPress?
How do I disable Gutenberg and keep the classic editor in WordPress? How do I disable Gutenberg editor in WordPress? How do I disable Gutenberg editor...