Comment on Updating a 50 terabyte PostgreSQL database (2018)parentComments−aantix4yWith 50TB, and if you were doing a full text search, wouldn't the entirety of the index have to be held in memory?−duskwuff4yNo. Full-text indexes exist.−Groxx4yYou can also do an incremental/streaming search. Lots of ways to avoid loading it all into memory at once, yeah.
Comments
With 50TB, and if you were doing a full text search, wouldn't the entirety of the index have to be held in memory?
No. Full-text indexes exist.
You can also do an incremental/streaming search. Lots of ways to avoid loading it all into memory at once, yeah.