Hacker News new | ask | show | jobs
by kuschku 1337 days ago
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.

If you'd like, I can build a small demo.

1 comments

Lol no thanks, once you hit the server I’m good, it’s more about the UI for me.