Ref- https://wordpress.org/support/topic/huge-postmeta-table/
This issue raised before in the link above was closed with no seemingly obvious fix. I also have a large table and it seems to be affecting the store performance.
Can we get an update from the team. I assume we can’t drop this table?
TY