Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-12 Thread Magnus Hagander
Jean-Michel Pouré wrote: > IMHO, it would be better if PostgreSQL parser was able to find Tseach > indexes alone, rewritting the query automatically. Maybe it is on the > radar list of hackers. How would you "rewrite a query automatically"? PostgreSQL will find it automatically when you attempt t

Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-12 Thread Jean-Michel Pouré
Le samedi 10 mars 2007 à 08:32 +0300, Oleg Bartunov a écrit : > btw, we're working on new FTS feature of PostgreSQL, it's basically > tsearch integrated into the pg core. But it has some new features and > new SQL commands for configuring of FTS, so if the matter is not > pressing I'd recommend >

Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-12 Thread cedric
Le samedi 10 mars 2007 06:32, Oleg Bartunov a écrit : > On Fri, 9 Mar 2007, Jean-Michel Pour? wrote: > > Le vendredi 09 mars 2007 ЪЪ 10:58 +0100, Magnus Hagander a ЪЪcrit : > >> No idea. Assuming you want to do it beforehand. otherwise, just create > >> the index and see how large it got? > > > > T

Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-09 Thread Oleg Bartunov
On Fri, 9 Mar 2007, Jean-Michel Pour? wrote: Le vendredi 09 mars 2007 ЪЪ 10:58 +0100, Magnus Hagander a ЪЪcrit : No idea. Assuming you want to do it beforehand. otherwise, just create the index and see how large it got? Thank you for your comments. I will add TSeach2 support to phpBB 3.x soon

Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-09 Thread Jean-Michel Pouré
Le vendredi 09 mars 2007 à 10:58 +0100, Magnus Hagander a écrit : > No idea. Assuming you want to do it beforehand. otherwise, just create > the index and see how large it got? Thank you for your comments. I will add TSeach2 support to phpBB 3.x soon. I had incredible response time on simple que

Re: [GENERAL] Tsearch2 / Create rule on select

2007-03-09 Thread Magnus Hagander
On Thu, Mar 08, 2007 at 09:56:23PM +0100, Jean-Michel Pouré wrote: > Dear Friends, > > I am very impressed by TSearch2 and would like to thank Oleg and the > team for their hard work. > > I would like to migrate a phpBB forum with more that 200.000 messages to > TSeach. Full text searches have be

[GENERAL] Tsearch2 / Create rule on select

2007-03-08 Thread Jean-Michel Pouré
Dear Friends, I am very impressed by TSearch2 and would like to thank Oleg and the team for their hard work. I would like to migrate a phpBB forum with more that 200.000 messages to TSeach. Full text searches have become a bottleneck. When there are more than 200 users, the server slow dramatical