search?

Open dzmitry-lahoda opened this issue 7 years ago • 2 comments

es is for search. right? would you be able to add full text search over jsonb in your blog post?

Nov 28 '18 20:11 dzmitry-lahoda

hi @dzmitry-lahoda If you are using postgres version 10+ you can full text search on json/jsonb. But I think ES will always have a better full text search than postgres

https://www.postgresql.org/docs/current/functions-textsearch.html
https://www.depesz.com/2017/04/04/waiting-for-postgresql-10-full-text-search-support-for-json-and-jsonb/

Nov 29 '18 08:11 komuw

thanks for the links! my second point was in order to better argue postgresql timescale db as replacement for es the blog should declare jsonb content as full text search and do example of search. why could I know that timescale does support full text search? i it is fine that es is better search and may be faster search, but for logs there is something good enough is enough.

Nov 29 '18 10:11 dzmitry-lahoda