Sorry, but string prefix search over a few hundred million entries is something you can do with the same performance using just postgres on a single server with just a few hours of dev time.
I've done it before, it's not as impressive as it seems.
With trigrams you can even do precise substring search on this scale with good performance.
I've done it before, it's not as impressive as it seems.
With trigrams you can even do precise substring search on this scale with good performance.
If you'd like, I can build a small demo.