Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F22002E005B for ; Thu, 28 Feb 2008 04:57:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12934-06 for ; Thu, 28 Feb 2008 04:57:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id C05FB2E0030 for ; Thu, 28 Feb 2008 04:57:36 -0400 (AST) Received: by svr2.hagander.net (Postfix, from userid 1000) id D7094DCCBF1; Thu, 28 Feb 2008 09:57:34 +0100 (CET) Date: Thu, 28 Feb 2008 09:57:34 +0100 From: Magnus Hagander To: Oleg Bartunov Cc: Gevik Babakhani , 'PostgreSQL - WWW ML' Subject: Re: www search behaviour Message-ID: <20080228085734.GH13189@svr2.hagander.net> References: <004a01c879a3$874b7a80$0a01a8c0@gevmus> <20080228082525.GD13189@svr2.hagander.net> <003f01c879e6$8ecdf380$0a01a8c0@gevmus> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/238 X-Sequence-Number: 14107 On Thu, Feb 28, 2008 at 11:54:34AM +0300, Oleg Bartunov wrote: > On Thu, 28 Feb 2008, Gevik Babakhani wrote: > > >>Yeah, it's climbing up my TODO list... > > > >Anything that I can do to help? > > Several variants: > > 1. Create custom parser for pgweb, which doesn't mean that '_' is a > separator > 2. Create synonym dictionary for pgweb, which lists all pg specific > terms > > 1. is a most right way, 2. is a most easy way, just create word stats, > see all terms with '_' and create pgvars dictionary like > some_word some_word Didn't we also talk about option 3, a custom dictionary that strips the underscores? Where could poteitnally use the regexp one as well? If you do pt 2, I can put it in right away. It'll take a reindexing of the whole db though. (Well, any of the options will) > Then created text search configuration , test it and give it to Magnus. > btw, Magnus, did you move to 8.3 ? Yes, we're on 8.3. And it's great ;-) //Magnus