5 ms·
The example here only covers short text fields like titles — does anyone know if it performant for full body search of long documents?
by nbashaw 3y ago
The example here only covers short text fields like titles — does anyone know if it performant for full body search of long documents?
- simonw 3y agoYes, it works great for that.
- nr2x 3y agoDepends on the length of the documents as well. I’ve used psql with smaller datasets and it’s fine, but it starts to have issues when you go bigger.
- sequence7 3y agoYes, it works well but there is a limit of 16k words. See this reddit comment thread [0] for more details, but if your documents are anywhere near that big then I'd say Postgres is definitely not the right tool for you. [0] https://www.reddit.com/r/programming/comments/12yhhcg/comment/jhne71q/?utm_source=share&utm_medium=web2x&context=3 https://www.reddit.com/r/programming/comments/12yhhcg/commen...
- puika 3y agoYes, and if it falls short you can also use the RUM extension if you don't mind the extra index size (can install via package manager or maybe you db provider like supabase has it available)