This is sorta mitigated by partitioning or sharding though right?

Too bad it's sorta annoying to do on plain old pg.