It’s 8G of data in memory. You can raw dog that no problem.

(Indexes would be nice though)

This is about getting the planner to more effectively use your 'proper indexes', concerned with the edge cases where it currently does not.