At a minimum, your indexes must fit into RAM. If they do not, you are in for pain. If you can get your data to fit into memory, that's an added bonus, but not

At a minimum, your indexes must fit into RAM. If they do not, you are in for pain. If you can get your data to fit into memory, that's an added bonus, but not necessarily required for smooth operation, depending on your use cases.