Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Bayer, Samuel" <sam(at)mitre(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Atri Sharma <atri(dot)jiit(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
Date: 2022-03-04 16:44:26
Message-ID: YiJB6k98GXmMCwI1@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 4, 2022 at 11:39:39AM -0500, Bayer, Samuel wrote:
> I've tried both ranking functions. I've tried a variety of the
> normalization settings. I'm using the standard English language
> configuration. Postgres 13.
>
> I do understand your FTS philosophy - I suppose I'm looking for
> guidance about how best to approximate the search capability in Solr
> using the FTS pieces you have. One concrete question, I suppose,
> is: the classic TF/IDF search strategy relies on inverse document
> frequency, which looks across the corpus. I can't tell whether that
> corpus-wide frequency information is taken into account in either
> ranking function.
>
> I don't know if Solr weights earlier tokens more heavily, but I
> wouldn't be surprised if it does.

Sorry, I don't know what corpus is or what you are asking?

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2022-03-04 16:45:42 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
Previous Message Tom Lane 2022-03-04 16:43:57 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres