
Morning all ...

	I'm going to do a broader announcement in a couple of days, but
Oleg and his gang have just finished setting up their Mailing List
Searching software ...

	If you go to fts.postgresql.org, it is like night->day as far as
the old searching is concerned ...

	We have some more configuration work to do on it, to improve
performance, but if anyone has used the old interface, performance now is
such that even without much tuning on the backend, you no longer have time
for coffee between searches :)

	Try it, let us know of any bugs, and we'll do a bigger
announcement in a couple of days to the rest of the community ...

	Vince, can you fix the search links to point to this, as far as
the mailing list searches are concerned?  docs are still in udmsearch for
now ...

	*Major* thanks to Oleg and his group for making this available
to the community ... now searching is a useful function :)

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


Fri, 27 Apr 2001 13:44:09 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
The new, the improved ... FTS Searching of Mailing List Archives
On Fri, 27 Apr 2001, The Hermit Hacker wrote:

>
> Morning all ...
>
> 	I'm going to do a broader announcement in a couple of days, but
> Oleg and his gang have just finished setting up their Mailing List
> Searching software ...
>
> 	If you go to fts.postgresql.org, it is like night->day as far as
> the old searching is concerned ...
>
> 	We have some more configuration work to do on it, to improve
> performance, but if anyone has used the old interface, performance now is
> such that even without much tuning on the backend, you no longer have time
> for coffee between searches :)
>
> 	Try it, let us know of any bugs, and we'll do a bigger
> announcement in a couple of days to the rest of the community ...
>
> 	Vince, can you fix the search links to point to this, as far as
> the mailing list searches are concerned?  docs are still in udmsearch for
> now ...
>
> 	*Major* thanks to Oleg and his group for making this available
> to the community ... now searching is a useful function :)

It *is* alot quicker.  I did a search for "scrappy" on All Lists and
it came back in 0.151 secs.  But it only found 104 matches, have you
been that quiet Marc?

I'll add it over the weekend.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Fri, 27 Apr 2001 12:55:30 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: The new, the improved ... FTS Searching of Mailing List Archives

Actually, default appears to be the last month worth of messages ... check
your date range :)


On Fri, 27 Apr 2001, Vince Vielhaber wrote:

> On Fri, 27 Apr 2001, The Hermit Hacker wrote:
>
> >
> > Morning all ...
> >
> > 	I'm going to do a broader announcement in a couple of days, but
> > Oleg and his gang have just finished setting up their Mailing List
> > Searching software ...
> >
> > 	If you go to fts.postgresql.org, it is like night->day as far as
> > the old searching is concerned ...
> >
> > 	We have some more configuration work to do on it, to improve
> > performance, but if anyone has used the old interface, performance now is
> > such that even without much tuning on the backend, you no longer have time
> > for coffee between searches :)
> >
> > 	Try it, let us know of any bugs, and we'll do a bigger
> > announcement in a couple of days to the rest of the community ...
> >
> > 	Vince, can you fix the search links to point to this, as far as
> > the mailing list searches are concerned?  docs are still in udmsearch for
> > now ...
> >
> > 	*Major* thanks to Oleg and his group for making this available
> > to the community ... now searching is a useful function :)
>
> It *is* alot quicker.  I did a search for "scrappy" on All Lists and
> it came back in 0.151 secs.  But it only found 104 matches, have you
> been that quiet Marc?
>
> I'll add it over the weekend.
>
> Vince.
> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
>          56K Nationwide Dialup from $16.00/mo at Pop4 Networking
>         Online Campground Directory    http://www.camping-usa.com
>        Online Giftshop Superstore    http://www.cloudninegifts.com
> ==========================================================================
>
>
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


Fri, 27 Apr 2001 14:07:09 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: The new, the improved ... FTS Searching of Mailing List Archives
On Fri, 27 Apr 2001, The Hermit Hacker wrote:

>
> Actually, default appears to be the last month worth of messages ... check
> your date range :)

I did, I just find it hard to believe that *you* of all people were
that quiet!  I did some other searches since then for things like 7.1
where I knew I'd get alot of hits.  Very impressive speeds!


>
>
> On Fri, 27 Apr 2001, Vince Vielhaber wrote:
>
> > On Fri, 27 Apr 2001, The Hermit Hacker wrote:
> >
> > >
> > > Morning all ...
> > >
> > > 	I'm going to do a broader announcement in a couple of days, but
> > > Oleg and his gang have just finished setting up their Mailing List
> > > Searching software ...
> > >
> > > 	If you go to fts.postgresql.org, it is like night->day as far as
> > > the old searching is concerned ...
> > >
> > > 	We have some more configuration work to do on it, to improve
> > > performance, but if anyone has used the old interface, performance now is
> > > such that even without much tuning on the backend, you no longer have time
> > > for coffee between searches :)
> > >
> > > 	Try it, let us know of any bugs, and we'll do a bigger
> > > announcement in a couple of days to the rest of the community ...
> > >
> > > 	Vince, can you fix the search links to point to this, as far as
> > > the mailing list searches are concerned?  docs are still in udmsearch for
> > > now ...
> > >
> > > 	*Major* thanks to Oleg and his group for making this available
> > > to the community ... now searching is a useful function :)
> >
> > It *is* alot quicker.  I did a search for "scrappy" on All Lists and
> > it came back in 0.151 secs.  But it only found 104 matches, have you
> > been that quiet Marc?
> >
> > I'll add it over the weekend.
> >
> > Vince.
> > --
> > ==========================================================================
> > Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
> >          56K Nationwide Dialup from $16.00/mo at Pop4 Networking
> >         Online Campground Directory    http://www.camping-usa.com
> >        Online Giftshop Superstore    http://www.cloudninegifts.com
> > ==========================================================================
> >
> >
> >
> >
>
> Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org
>
>

-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Fri, 27 Apr 2001 13:14:17 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: The new, the improved ... FTS Searching of Mailing List Archives
On Fri, 27 Apr 2001, Vince Vielhaber wrote:

> It *is* alot quicker.  I did a search for "scrappy" on All Lists and
> it came back in 0.151 secs.  But it only found 104 matches, have you
> been that quiet Marc?

I got 3604 messages for the period from 1995 to now.
                                        ^^^^^
	Oleg

>
> I'll add it over the weekend.
>
> Vince.
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 27 Apr 2001 20:24:59 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: Re: The new, the improved ... FTS Searching of Mailing
	List Archives
On Fri, 27 Apr 2001, The Hermit Hacker wrote:

>
> Morning all ...
>
> 	I'm going to do a broader announcement in a couple of days, but
> Oleg and his gang have just finished setting up their Mailing List

All work was done by Teodor Sigaev (teodor@stack.net) and me (oleg@sai.msu.su)
as real-life application which utilize our work on GiST for 7.1
There is a room for improving performance - partial sorting
and better support of gist indexes by optimizer. We hope core developers
could help us.

>
> 	*Major* thanks to Oleg and his group for making this available
> to the community ... now searching is a useful function :)

We need to write some doc, FAQ. Also, we plan to add indexing of
postgres documentation, so people could search in mailing list archive
and docs.

>
> Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 27 Apr 2001 20:36:43 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: The new, the improved ... FTS Searching of Mailing List Archives
> 	Vince, can you fix the search links to point to this, as far as
> the mailing list searches are concerned?  docs are still in udmsearch for
> now ...
> 
> 	*Major* thanks to Oleg and his group for making this available
> to the community ... now searching is a useful function :)

And something to add to 7.2!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 13:44:46 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: The new, the improved ... FTS Searching of Mailing List Archives
On Fri, 27 Apr 2001, Bruce Momjian wrote:

> > 	Vince, can you fix the search links to point to this, as far as
> > the mailing list searches are concerned?  docs are still in udmsearch for
> > now ...
> >
> > 	*Major* thanks to Oleg and his group for making this available
> > to the community ... now searching is a useful function :)
>
> And something to add to 7.2!

Huh? *raised eyebrow*  This is a standalone application that they've
donated to the project ... nothing that can be added to any of our
distributions ...


Fri, 27 Apr 2001 15:11:45 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: The new, the improved ... FTS Searching of Mailing List Archives
> On Fri, 27 Apr 2001, Bruce Momjian wrote:
> 
> > > 	Vince, can you fix the search links to point to this, as far as
> > > the mailing list searches are concerned?  docs are still in udmsearch for
> > > now ...
> > >
> > > 	*Major* thanks to Oleg and his group for making this available
> > > to the community ... now searching is a useful function :)
> >
> > And something to add to 7.2!
> 
> Huh? *raised eyebrow*  This is a standalone application that they've
> donated to the project ... nothing that can be added to any of our
> distributions ...

Isn't the text indexing something that can go into the distribution?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 14:20:12 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: The new, the improved ... FTS Searching of Mailing List Archives
On Fri, 27 Apr 2001, Bruce Momjian wrote:

> > On Fri, 27 Apr 2001, Bruce Momjian wrote:
> >
> > > > 	Vince, can you fix the search links to point to this, as far as
> > > > the mailing list searches are concerned?  docs are still in udmsearch for
> > > > now ...
> > > >
> > > > 	*Major* thanks to Oleg and his group for making this available
> > > > to the community ... now searching is a useful function :)
> > >
> > > And something to add to 7.2!
> >
> > Huh? *raised eyebrow*  This is a standalone application that they've
> > donated to the project ... nothing that can be added to any of our
> > distributions ...
>
> Isn't the text indexing something that can go into the distribution?

to the best of my knowledge, everything they had for public consumption
was added to v7.1, but Oleg would be better for that ... to get
fts.postgresql.org, there was nothing special I had to do as far as the
backend was concerned *shrug*



Fri, 27 Apr 2001 15:44:15 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: The new, the improved ... FTS Searching of Mailing List Archives
At 03:44 PM 27-04-2001 -0300, The Hermit Hacker wrote:
>On Fri, 27 Apr 2001, Bruce Momjian wrote:
>
>> > On Fri, 27 Apr 2001, Bruce Momjian wrote:
>> >
>> > Huh? *raised eyebrow*  This is a standalone application that they've
>> > donated to the project ... nothing that can be added to any of our
>> > distributions ...
>>
>> Isn't the text indexing something that can go into the distribution?
>
>to the best of my knowledge, everything they had for public consumption
>was added to v7.1, but Oleg would be better for that ... to get
>fts.postgresql.org, there was nothing special I had to do as far as the
>backend was concerned *shrug*

<featurerequest>
Well if stuff like that ends up in Postgresql would it be possible to index
LIKE '%xxx%' searches? That way all people have to do is create the
relevant index and use a fts_ops or something, and voila LIKE '%xxx%'
searches become faster, with maybe some performance+disk space hit for
inserts.

Would something like that be difficult to implement? I'm not sure how
function+fts index would work either.

I hope FTS for postgresql doesn't start looking like Oracle's
Context/Intermedia... Proprietary interfaces == "lock in" == "ick".
</featurerequest>

Cheerio,
Link.


Sat, 28 Apr 2001 09:29:35 +0800
Lincoln Yeoh <lyeoh@pop.jaring.my>
Re: The new, the improved ... FTS Searching of Mailing List Archives
> <featurerequest>
> Well if stuff like that ends up in Postgresql would it be possible to index
> LIKE '%xxx%' searches? That way all people have to do is create the
> relevant index and use a fts_ops or something, and voila LIKE '%xxx%'
> searches become faster, with maybe some performance+disk space hit for
> inserts.
> 
> Would something like that be difficult to implement? I'm not sure how
> function+fts index would work either.
> 
> I hope FTS for postgresql doesn't start looking like Oracle's
> Context/Intermedia... Proprietary interfaces == "lock in" == "ick".
> </featurerequest>

This is what I was hoping... Something to make it automatic.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 21:45:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: The new, the improved ... FTS Searching of Mailing
	List  Archives
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> > I hope FTS for postgresql doesn't start looking like Oracle's
> > Context/Intermedia... Proprietary interfaces == "lock in" == "ick".
> > </featurerequest>
> 
> This is what I was hoping... Something to make it automatic.
> 

Well, I would love to see full text indexing with some understanding of the
language in question as well - I believe this is what Oracles product is
about and not just simple regexp matching. I want to be able to do regexps,
synonyms, soundex, etc. And I guess there is no standard for specifying
these different kind of searches. 

regards, 

	Gunnar 

03 May 2001 16:55:29 +0200
Gunnar R|nning <gunnar@candleweb.no>
Re: Re: The new,
	the improved ... FTS Searching of Mailing  List  Archives