Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
The Hermit Hacker wrote: > > And, actually, for some reason I hadn't thought of the tsearch as being > another 'INDEX' type ... I crawl back over and be quiet now :) > > Oleg, as far as commits are concerned, I have no problems with extending > the privileges to one of your guys for this, just email me seperately who, > and I'll get it setup ... That would help me too. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
And, actually, for some reason I hadn't thought of the tsearch as being another 'INDEX' type ... I crawl back over and be quiet now :) Oleg, as far as commits are concerned, I have no problems with extending the privileges to one of your guys for this, just email me seperately who, and I'll get it setup ... On Fri, 20 Jun 2003, Oleg Bartunov wrote: > On Fri, 20 Jun 2003, Christopher Kings-Lynne wrote: > > > > Why part of the core distribution, and not just left as a loadable module, > > > like it is now? > > > > The day I can go 'CREATE FULLTEXT INDEX ...' just like MySQL can I will be a > > very happy chappy... > > > > with new tserach v2 we're pretty close to that day. we need more testing, > more suggestions and more documentation. There are several issues remains, > mostly with core GiST not tsearch. The most important is concurrency support ! > We've several times planned to work on it, but real life is rather complex > thing :( > > > Chris > > > > > > ---(end of broadcast)--- > > TIP 8: explain analyze is your friend > > > > Regards, > Oleg > _ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: [EMAIL PROTECTED]|postgresql}.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Fri, 20 Jun 2003, Christopher Kings-Lynne wrote: > > Why part of the core distribution, and not just left as a loadable module, > > like it is now? > > The day I can go 'CREATE FULLTEXT INDEX ...' just like MySQL can I will be a > very happy chappy... > with new tserach v2 we're pretty close to that day. we need more testing, more suggestions and more documentation. There are several issues remains, mostly with core GiST not tsearch. The most important is concurrency support ! We've several times planned to work on it, but real life is rather complex thing :( > Chris > > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
The Hermit Hacker kirjutas R, 20.06.2003 kell 08:28: > On Fri, 20 Jun 2003, Tom Lane wrote: > > > > On Fri, 20 Jun 2003, The Hermit Hacker wrote: > > > Is there a strong reason why tsearch isn't in gborg? > > > > I think text search is a pretty important facility that should > > eventually be part of the core distribution. It's more likely to get > > there from contrib than from gborg ... > > Why part of the core distribution, and not just left as a loadable module, > like it is now? I remember Tom saying that builtin functions calls are a lot faster than loadable C functions. If that can be fixed, then it *could* stay loadable. Also, having built-in full text indexing is very desirable. And I don't see any even nearly as good competing fulltext indexing modules anywhere. If we had to move something *out* of core in order to get tsearch in, then I personally would not mind if all geometry types go to gborg, but I'm sure there are some users who would mind ;) --- Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
> Why part of the core distribution, and not just left as a loadable module, > like it is now? The day I can go 'CREATE FULLTEXT INDEX ...' just like MySQL can I will be a very happy chappy... Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Fri, 20 Jun 2003, Tom Lane wrote: > > On Fri, 20 Jun 2003, The Hermit Hacker wrote: > > Is there a strong reason why tsearch isn't in gborg? > > I think text search is a pretty important facility that should > eventually be part of the core distribution. It's more likely to get > there from contrib than from gborg ... Why part of the core distribution, and not just left as a loadable module, like it is now? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
> On Fri, 20 Jun 2003, The Hermit Hacker wrote: > Is there a strong reason why tsearch isn't in gborg? I think text search is a pretty important facility that should eventually be part of the core distribution. It's more likely to get there from contrib than from gborg ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Fri, 20 Jun 2003, The Hermit Hacker wrote: > On Fri, 20 Jun 2003, Oleg Bartunov wrote: > > > > Is there a strong reason why tsearch isn't in gborg? > > > > > > > How gborg could help us submitting changes to pgsql CVS ? > > It wouldn't ... is there a reason why tsearch needs to be in the pgsql CVS > any more then, say, ODBC drivers, or the tcl interface, or the python > interface, or ... ? because tsearch lives under pgsql source tree, in contrib directory though. I'd never asked for any rights (I have enough beside postgresq :), but practice of development life is so, that Bruce has no time to apply them in reasonable time. Last patch waited about 1 month. I'd like to see tsearch in contrib directory because we have direct benefit from that - rather often Tom change contrib sources to sync with his changes in main tree. This is the only real reason why I want to stay under postgres tree. I was afraid, and Bruce actually wrote he will be busy, we couldn't submit our new version. Freebsd has separate rights for core and ports. > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Fri, 20 Jun 2003, Oleg Bartunov wrote: > > Is there a strong reason why tsearch isn't in gborg? > > > > How gborg could help us submitting changes to pgsql CVS ? It wouldn't ... is there a reason why tsearch needs to be in the pgsql CVS any more then, say, ODBC drivers, or the tcl interface, or the python interface, or ... ? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Thu, 19 Jun 2003, The Hermit Hacker wrote: > On Thu, 19 Jun 2003, Oleg Bartunov wrote: > > > I'm not sure if contrib/tsearch is a "killer" feature, but we hope to > > submit completely new version of tsearch V2 before July 1. Actually, we > > have stable code already used in some projects but currently lacking > > documentation. Several people are working on tutorial, reference guide. > > The problem is that Bruce seems is very overloaded and for sure he'll > > have many patches close to July 1. Is it possible to get rights to > > commit our changes ? > > Is there a strong reason why tsearch isn't in gborg? > How gborg could help us submitting changes to pgsql CVS ? > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
tsearch V2 (Was: Re: [HACKERS] Two weeks to feature freeze)
On Thu, 19 Jun 2003, Oleg Bartunov wrote: > I'm not sure if contrib/tsearch is a "killer" feature, but we hope to > submit completely new version of tsearch V2 before July 1. Actually, we > have stable code already used in some projects but currently lacking > documentation. Several people are working on tutorial, reference guide. > The problem is that Bruce seems is very overloaded and for sure he'll > have many patches close to July 1. Is it possible to get rights to > commit our changes ? Is there a strong reason why tsearch isn't in gborg? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster