Re: Let's play bash the search engine - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Let's play bash the search engine
Date
Msg-id 20061219131613.GA10319@svr2.hagander.net
Whole thread Raw
In response to Re: Let's play bash the search engine  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
On Tue, Dec 19, 2006 at 01:24:01PM +0100, Magnus Hagander wrote:
> On Tue, Dec 19, 2006 at 01:13:16PM +0300, Oleg Bartunov wrote:
> > >Seems to_tsvecto() returns NULL for tsearch2 or for, as you say,
> > >anything that ends in a digit.
> > >
> > >Oleg, can you comment on why this is happening? What can we do to fix
> > >that?
> >
> > Most probably, token type 'word' just doesn't indexed. If you
> > didnt' correct this from pgweb configuration:
> >
> > -- we won't index/search some tokens
> > update pg_ts_cfgmap set dict_name = NULL
> > where tok_alias in ('email', 'url', 'sfloat', 'uri', 'float','word')
> > and ts_name = 'pg';
>
> That sounds like it's the problem. I'll update the configuration, and I
> assume I have to regenerate all the tsvectors as well, right?
>
> Should I set it to 'simple' or one of the others?

This has now been fixed for both website and archive search. So now you
can search for the technology that made the search possible in the first
place again :-)

//Magnus

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Let's play bash the search engine
Next
From: Christopher Browne
Date:
Subject: Re: Second attempt, roll your own autovacuum