full-text-search Archives

Full Text Search With PostgreSQL

By adminPosted on October 5, 2022

Question : i have a table with this rows: Stickers —————————————————— ID | Title |Keywords (ts_vector) —————————————————— 01 | Sticker […]

By adminPosted on October 1, 2022

Question : Data ~5M documents, would love to have ~223M, with the text of ~10-1000 words each. It must be […]

By adminPosted on September 28, 2022

Question : I have a list of people that varies between 2-5k entries that has this general format: firstname1 lastname1, […]

By adminPosted on September 28, 2022

Question : I’m struggling with an n-gram problem and have been hunting the Web for examples to help me out […]

By adminPosted on September 28, 2022

Question : I have created this index ORACLE/VIDEO# create index titolo_index 2 on titolo(titolo) 3 indextype is ctxsys.context 4 ONLINE […]

By adminPosted on September 27, 2022

Question : Is it possible to run a full text search on an FTS-indexed column for all values in another […]

By adminPosted on September 22, 2022

Question : MATCH (col1,col2,…) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY […]

By adminPosted on September 22, 2022

Question : I have a table that stores a conversation between two people. The data will look something like this: […]

By adminPosted on September 22, 2022

Question : I’ve a problem in my DB (PGSQL 9.6) that I’ve not been able to resolve and I don’t […]

By adminPosted on September 20, 2022

Question : I have an asp.net website with many insert, update, and delete queries running against my database. A few […]