Re: [GENERAL] tsearch2 questions

2007-07-04 Thread Joshua N Pritikin
On Wed, Jul 04, 2007 at 11:08:21AM +0200, hubert depesz lubaczewski wrote: > On 7/4/07, Joshua N Pritikin <[EMAIL PROTECTED]> wrote: > >From where are you quoting? I was quoting from: > > > >http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-ref.html > > i was quoting file > http

Re: [GENERAL] tsearch2 questions

2007-07-04 Thread hubert depesz lubaczewski
On 7/4/07, Joshua N Pritikin <[EMAIL PROTECTED]> wrote: From where are you quoting? I was quoting from: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-ref.html i was quoting file http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html or actual

Re: [GENERAL] tsearch2 questions

2007-07-04 Thread Joshua N Pritikin
On Wed, Jul 04, 2007 at 10:40:11AM +0200, hubert depesz lubaczewski wrote: > On 7/4/07, Joshua N Pritikin <[EMAIL PROTECTED]> wrote: > >Please mention that in the documentation: > > dont you think this is perfeclty clear? > > "If you want to do something specific with columns, you may write your

Re: [GENERAL] tsearch2 questions

2007-07-04 Thread hubert depesz lubaczewski
On 7/4/07, Joshua N Pritikin <[EMAIL PROTECTED]> wrote: Please mention that in the documentation: dont you think this is perfeclty clear? "If you want to do something specific with columns, you may write your very own trigger function using plpgsql or other procedural languages (but not SQL,

Re: [GENERAL] tsearch2 questions

2007-07-04 Thread Joshua N Pritikin
On Wed, Jul 04, 2007 at 10:59:46AM +0400, Oleg Bartunov wrote: > On Wed, 4 Jul 2007, Joshua N Pritikin wrote: > >1. What is the advantage of the tsearch2() trigger? Why can't I write my > >own trigger which does approximately: > > no advantage, it's just an example. Please mention that in the doc

Re: [GENERAL] tsearch2 questions

2007-07-04 Thread Oleg Bartunov
On Wed, 4 Jul 2007, Joshua N Pritikin wrote: 1. What is the advantage of the tsearch2() trigger? Why can't I write my own trigger which does approximately: no advantage, it's just an example. UPDATE manuscript set manuscript_vector = setweight(to_tsvector(manuscript_genre), 'A') ||

Re: [GENERAL] TSearch2 Questions

2005-11-22 Thread Hannes Dorbath
On 21.11.2005 18:24, Bruno Wolff III wrote: On Mon, Nov 21, 2005 at 16:50:00 +0300, Oleg Bartunov wrote: On Mon, 21 Nov 2005, Hannes Dorbath wrote: I'm playing a bit with it ATM. Indexing one Gigabyte of plain text worked well, with 10 GB I yet have some performance problems. I read the TSear

Re: [GENERAL] TSearch2 Questions

2005-11-21 Thread Bruno Wolff III
On Mon, Nov 21, 2005 at 16:50:00 +0300, Oleg Bartunov wrote: > On Mon, 21 Nov 2005, Hannes Dorbath wrote: > > >I'm playing a bit with it ATM. Indexing one Gigabyte of plain text worked > >well, with 10 GB I yet have some performance problems. I read the TSearch > >Tuning Guide and will start

Re: [GENERAL] TSearch2 Questions

2005-11-21 Thread Oleg Bartunov
On Mon, 21 Nov 2005, Hannes Dorbath wrote: A few stupid questions: Where to get the latest version? Is http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ a dead site and the latest versions are always "silently" distributed with PG inside the contrib dir? You should always use tsearch