3 ms·

With 50TB, and if you were doing a full text search, wouldn't the entirety of the index have to be held in memory?

• duskwuff 5y ago
  No. Full-text indexes exist.
  • Groxx 5y ago
    You can also do an incremental/streaming search. Lots of ways to avoid loading it all into memory at once, yeah.