[nbashaw]

The example here only covers short text fields like titles — does anyone know if it performant for full body search of long documents?

[sequence7]

Yes, 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/commen...

[puika]

Yes, 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)

[simonw]

Yes, it works great for that.

[nr2x]

Depends 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.