https://www.percona.com/blog/2019/06/14/bloom-indexes-in-postgresql/

I think having an option to use bloom filter indexes could provide for better performance when compared to compound indexes and eliminate the need for having multiple indexes. It would likely require tuning still, but with very large data sets this could be much less expensive.