All geek questions in one place

Getting the most common keywords from the tsvector column

I am considering adding a tsvector column to an existing table that will contain possible search conditions for multiple columns in the same table (for example, the tsvector column will be equal to_tsvector(header || ' ' || body || ' ' || footer)). Before I decided to do this, one of my requirements is that I can find the most popular keywords among all the entries in the table.

Is there something similar to tsquery that will find my most popular keywords across all entries?

+3
source share
1 answer

Most likely, the ts_stat FTS function is what you need.

+4

Source: https://habr.com/ru/post/1724797/

More articles:


All Articles