Postgres Full Text Search скачать в хорошем качестве

Postgres Full Text Search

Video explores PostgreSQL full text search capabilities, creating and indexing text documents and providing search capabilities. Postgres introduces two new datatypes to support full test search, tsvector and tsquery. Tsvector represents document in form suitable for searching and tsquery a predicate that documents you’re searching on needs to satisfy. Postgres also supports misspelling suggestions with pg_trgm trigram extension and synonyms searches by dictionary and search configuration extension. To make you searches performant we’ll use indexes on search columns. Finally, we demonstrate search concepts in action on java spring boot demo web app. github link: https://github.com/kanezi/postgres-fts 00:00 - intro 00:27 - full text search 01:45 - lucene index & search 02:16 - sample pg project 03:56 - pg regular text search operators 06:14 - pg full text search parts 07:27 - tsvector 09:30 - stop words 11:02 - unnacent 11:30 - parsing and translating 12:48 - tsquery 14:49 - @@ operator 16:00 - || && operators 16:59 - ranking 18:59 - ts_headline 19:44 - synonyms 21:00 - indexing 25:50 - select for web ui 27:14 - synonyms 30:49 - java spring app example 32:48 - outro